Investigate ASYNC_NETWORK_IO with request and task evidence, check client consumption, and separate large outputs from network faults.
SQL SERVER – Reverse String Word By Word Part 2
In Reverse String Word By Word Part 2, Sanjay Monpara and Yuri Petrov improve my script. The new, more robust version uses a Split function.
Primary Data File Extensions: Does the .mdf Name Matter?
Can a primary data file end in something other than .mdf? I built a demo database with odd names, checked each file, then detached and attached it.
Reading a Workload Capture Without a Tool
Read a workload capture by grouping related queries, comparing total resource use, and separating one slow execution from repeated work.
Physical Reads per Query: Finding What Drives Disk I/O
The storage team asks which query hit the disks. Here is how to answer with physical reads, and why the answer depends on how you rank them.
Hey DBA – Baselines and Performance Monitoring – Why? – Notes from the Field #058
Mike Walsh explains why baselines and performance monitoring matter for every DBA, and how to know what normal looks like on your servers.
SQL SERVER – List the Name of the Months Between Date Ranges
How do you list the name of the months between date ranges? A friend and former co-worker sent me this script using DATENAME and DATEADD.
SQL SERVER – Finding if Current Week is Odd or Even – Script
A bank DBA needed a script to tell if the current week is odd or even, to keep more cash on the 2nd and 4th weeks. Here is the script I use.










