Equal row counts do not mean equal work, and patterned keys can pile into one bucket. Here is how to test your buckets before adding workers.
Wait Stats Collection Script for Current SQL Server Versions
A wait stats collection script saves snapshots of sys.dm_os_wait_stats into a table, so you can compare two snapshots instead of reading totals since the last restart. This post builds the tables and a snapshot procedure, creates a small load, and reports the change with a category for each wait. It also covers idle waits, restarts and retention.
Auto-Created Statistics: What the _WA_Sys Names Tell You
Read auto-created statistics through sys.stats and sys.stats_columns, then use their columns as clues for better query tuning.
Measure Page Splits in SQL Server With T-SQL
To measure page splits in SQL Server, read the Page Splits/sec counter twice and subtract the first reading from the second. This post loads a table with sequential keys and another with random keys, so you can see which splits are normal and which cost you. It also names the index behind the splits and shows how a lower fill factor removes most of them.
SQL SERVER – How to Change Database Compatibility Level?
Compatibility Level controls selected query behavior within a database. I baseline the workload before changing it.
Converting float to Text Without Losing Digits
The default float to text conversion keeps about six digits. Here is the one style that gives your float back exactly, and the traps around it.
Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107
Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.