Max degree of parallelism controls how many cores one query can use, and the vendor guidance for Microsoft Dynamics CRM has been 1. This post measures what parallel plans cost on a heavy and a small query. It shows a database scoped limit and the instance wide statements.
Rename Physical File Name of a SQL Server Database
To rename physical file name entries for a SQL Server database, take it offline, change the catalog with MODIFY FILE, rename the files in Windows and bring the database online. This post builds a demo, shows the error a missing file causes, and gives a way to undo the change.
How to Set ARITHABORT ON for .NET Applications
A query that runs fast in Management Studio and slow in a .NET application often runs under two different plans, because the two connections use different ARITHABORT settings. This post shows both plans in the plan cache, measures the cost, and explains how to set ARITHABORT ON for all connections through the server’s default connection options.
SQL SERVER – How to Listen on Multiple TCP Ports in SQL Server?
Can SQL Server listen on multiple TCP Ports? Yes, and here are the Configuration Manager steps I shared when a senior DBA asked me during a Health Check.
SQL SERVER – FIX: Error 14001: The Application Has Failed to Start Because its Side-by-side Configuration is Not Correct
A Jr. DBA’s SQL Server service would not start: Error 14001, the application’s side-by-side configuration is not correct. Here is how we found the cause.
SQL SERVER – What is Change Pending State of in SQL Server Configuration Manager?
During a rushed release, a client stopped SQL Server and the service got stuck. Here is what Change Pending State in Configuration Manager means and what to do.
SQL SERVER – What Does SET NOEXEC Do?
What does SET NOEXEC do? With SET NOEXEC ON, SQL Server compiles your query but does not run it. Here is how the compile and execute phases work.