Assign granular server roles in SQL Server 2022, inspect membership, and give monitoring accounts the state access their queries need.
Pages and Extents: How SQL Server Stores Rows in a Data File
Pages and Extents are the building blocks of every SQL Server data file. A page is 8 KB, an extent is eight pages, and a row has to fit on a page. This post shows how to count the pages a table uses and what happens when a row is too wide.
The Last Actual Execution Plan: LAST_QUERY_PLAN_STATS in Practice
Capture the last actual execution plan with LAST_QUERY_PLAN_STATS, inspect runtime rows, and understand what cache retention cannot provide.
Connection Pooling Problems: Timeouts, Leaks and Max Pool Size
Diagnose connection pooling timeouts with session counts, sleeping activity, open transactions, and client settings that divide pools.
SQL SERVER – sys.dm_xe_map_values – Reasons for Statement Recompilation
What are all the reasons a statement recompiles? I found the full list with the DMV sys.dm_xe_map_values, handy when you read a Profiler or Extended Events trace.
Overlapping Indexes With INCLUDE Columns: Merging Them Safely
Find overlapping indexes, compare ordered keys and INCLUDE lists, merge coverage carefully, and review usage before removing either index.
SQL SERVER – Identify Last User Access of Table using T-SQL Script
How do you find the last user access of a table? A question at TechEd India 2013 led to this quick DMV script. Keep in mind the data resets on restart.