Size hash index bucket count from distinct keys, inspect empty buckets and chains, rebuild a test index, and choose range indexes wisely.
SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10
Want to plot your own values, like rows in a table, next to standard PerfMon counters? The procedures sp_user_counter1 to sp_user_counter10 do just that.
SQL SERVER – Performance Counter Missing: How to Get Them Back?
A friend opened PerfMon and found every SQL Server performance counter missing for his instance. Here is how we got them back.
Azure SQL Database Wait Stats: Reading sys.dm_db_wait_stats
Read Azure SQL Database wait stats with sys.dm_db_wait_stats, identify log-rate governance, and compare resource percentages before scaling.
SQL SERVER – Do You Know Your Data’s Classification? – Notes from the Field #050
Tim Radney asks if you know your data’s classification, and explains why data professionals must know what data they hold and how sensitive it is.
SQL SERVER – Row Offset in SQL Server For Different Version
A common question is how to find row offset in SQL Server. I share paging examples for each version, from OFFSET FETCH in 2012 back to SQL Server 2000.
Finding Hot Tables With sys.dm_db_index_usage_stats
Identify hot tables with index usage, lock and latch counters, table sizes, and retained snapshots that describe a real workload interval.