SQL Performance

SEPTEMBER 6, 2022

Let’s look at some examples using a fresh database. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. USE master ; -- Create a new test database. -- COLLATE clause only to remind people it exists. GOTO Start.

Database 98

Database Storage Testing Servers 98

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. SSRS 2008 brought that component into the reporting service module. Unlike the system database tempdb, ReportServerTempDB is not recreated at startup.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Server According to Bob

JUNE 3, 2016

“SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster. The following table is taken from an ASP.NET, session state cache, stress test. SQL 2016 – It Just Runs Faster: In-Memory Optimized Database Worker Pool.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. The FastLoadContext code path adds support for minimally-logged and concurrent bulk load on: Empty and non-empty clustered b-tree indexes. There are two main code paths that can set DMLRequestSort to true for index inserts. The sqllang!CUpdUtil::FOptimizeInsert

Cache 64

Cache Testing Servers Code 64

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. That is to ensure your database is encrypted at the file level. The process to enable this for a database is described in our documentation. What does encrypted mean at this point?

Servers 40

Servers Database Azure Cache 40