Cost Threshold for Parallelism

Cost Threshold for Parallelism

One of the most common missed configuration settings in SQL Server is the cost threshold for parallelism. By default it is set to 5, meaning that when SQL estimates that the cost of a query will be greater than 5 running a serial plan, SQL will split the plan into...
What is AlwaysOn

What is AlwaysOn

AlwaysOn Availability Group (AG) is one of my favorite features in SQL Server and is worth considering when using SQL server 2012 or greater. One of the nicest features in AlwaysOn AG is that in a single subnet environment it can be totally transparent to your...
Upgrading the SHA-1 certificate in SQL Server

Upgrading the SHA-1 certificate in SQL Server

For some time now, SHA-1 has not been allowed to be issued from CA’s with few exceptions. This was due to a large catalog of evidence suggesting that SHA-1 was less secure than acceptable. Starting with SQL 2016 self-signed certificates are issued using SHA-2,...
Disk Configuration Optimized for SQL Server

Disk Configuration Optimized for SQL Server

While there are many configuration options in SQL Server that can help tweak the performance when RAM or CPU is causing a slowdown, when the disk is the culprit, your options are much more limited. Assuming that best practices are followed in regards to file locations...