Latch FGCB_ADD_REMOVE timeouts mean a data file is growing slowly. Measured on SQL Server 2025: 4 GB of data in 98 ms, 4 GB of log in 2.3 seconds.
Find Deprecated SQL Server Features with Extended Events
To find deprecated SQL Server features, capture the deprecation announcement and deprecation final support events with Extended Events. This post builds a small session, runs four kinds of deprecated code, reads the captured features and statements, and lists the replacements to use before a compatibility level change or an upgrade.
How to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165
Is your application using deprecated features that a future SQL Server may remove? Here is how SQL Server helps you find them, starting with a Profiler event.
Building a Data Dictionary Query From Extended Properties
A plain join quietly hides every column nobody described. See the LEFT JOIN that keeps them, and turn the gaps into a to-do list.
How to Find Running SQL Trace? – Interview Question of the Week #123
Question: How to Find Running SQL Trace? Once we know the trace exists, how to stop and delete them?
SQL SERVER – How to get historical deadlock Information from System Health Extended Events?
Let me start off by asking a simple question. How many of you have seen this error about historical deadlock information earlier?
Reading the system_health File Target With Plain T-SQL
Locate the system_health file target, read its retained events with T-SQL, and inspect serious errors, connectivity records and waits.