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.
SQL SERVER – Performance Dashboard – Historic Information
Travels with my daughter taught me the value of history. The Historic Information section of Performance Dashboard does the same for your SQL Server.
SQL SERVER – Database Taking Long Time to Create – Notes from the Field #047
Ever seen a database taking a long time to create? Tim Radney explains in simple words why it happens, based on a real question from a forum.
SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention
Why is it called a natively compiled stored procedure when the code is T-SQL? I explain, and show a DMV query that finds where its DLL is loaded from.