Changing the default folder does not move a single existing file. Here is how to read the defaults and spot databases that ignore them.
Tuning Step One: Capture a Wait Stats Baseline Before Changing Anything
Capture a wait stats baseline, compare two saved snapshots, reject reset intervals, and rank meaningful waits before changing settings.
SQL SERVER – DMV sys.dm_exec_describe_first_result_set_for_object – Describes the First Result Metadata for the Module
The SQL Server 2012 DMV sys.dm_exec_describe_first_result_set_for_object describes the result columns of a stored procedure.
Why a Second Log File Does Not Make Anything Faster
Adding a second log file feels like a speed fix, but it is only a spare room. Here is how to watch it work and how to retire it.
SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors
A friend needed to count Virtual Processors available to SQL Server 2000. Scripts for 2000 with xp_msver, and for 2005 to 2012 with sys.dm_os_sys_info.
Locking and Blocking Quiz: Will Updating a Different Row Wait?
This Locking and Blocking Quiz asks whether an update waits when it changes a different row than an open transaction. The answer depends on the index. A two-window test on SQL Server 2025 shows the wait, the lock that causes it, and two ways to remove it.
Diagnosing Connection Pool Exhaustion From the SQL Server Side
Diagnose connection pool exhaustion by grouping SQL Server sessions, finding sleeping open transactions, and reading their last command.