Build a performance baseline in SQL Server with saved waits, file latency, query CPU, and counters before judging a tuning change.
Disabling Nonclustered Indexes Before a Large Load, Then Rebuilding
Test disabling nonclustered indexes before a large load, rebuilding them afterward, and measuring total time and log use.
Uneven Parallelism: Spotting Skewed Threads Behind CXPACKET Waits
Diagnose uneven parallelism by comparing CXPACKET and CXCONSUMER with per-thread row counts in plans and live query profiles.
SQL SERVER – Concurrency Basics – Guest Post by Vinod Kumar
Vinod Kumar explains concurrency basics with a simple queue analogy: the shorter the line, the higher the concurrency, and how databases manage it with locks.
SQL SERVER – Find Rows and Index Count – SQL in Sixty Seconds #029 – Video
A quick script that lists each user table with its row count, index count and whether it is a heap or has a clustered index, with a short video walkthrough.
SARGable Date Filters: Stop Wrapping Columns in Functions
Write SARGable date filters as half-open ranges for years, months, days, and rolling windows, then compare plans and logical reads.
SQL SERVER – SQL Server Statistics Name and Index Creation
Guest author Sandip hit Msg 1913 while creating an index, because an index or statistics with that name already existed. A lesson on statistics name and index creation.