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...
Reducing the Use of TempDB to Keep Costs Down

Reducing the Use of TempDB to Keep Costs Down

There comes a time in everyone’s life that they need to be concerned about tempdb. I know… we all have configured it correctly and it’s running great. The application and all of the developers are using it like crazy …Wait… that may not be a good thing....
CTEs and Client Statistics

CTEs and Client Statistics

CTEs may not be used for performance but there are times they could help you from a performance standpoint. The following example uses the same logic written in a way to use three different types of temporary objects. It shows what is done with each process using...
Setup AD for AlwaysOn Listener

Setup AD for AlwaysOn Listener

When you create a new Availability Group there are a couple of administrative tasks that should be completed before creating your Availability Group within SQL Server. This will elevate any domain permission issues when you are trying to create your Availability Group...