Find free time slots with GENERATE_SERIES, exclude overlapping bookings, and merge busy intervals before calculating calendar gaps.
SQL SERVER – FIX: Msg 9514 – XML Data Type is Not Supported in Distributed Queries
Querying a table with an XML column over a linked server fails with Msg 9514: XML data type is not supported in distributed queries. Here is the fix.
SQL SERVER – Copy Data From SSMS Query Result to Excel
How do you copy data from an SSMS query result to Excel? It is simple, but not everyone knows it: right-click the results and save them as a CSV file.
Clear the Plan Cache for a Single Database in SQL Server
To clear the plan cache for one database, use ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE in that database. This post tests it on two small databases, compares it with DBCC FLUSHPROCINDB and with freeing a single plan, and explains why DBCC FREEPROCCACHE is a bad habit.
Reduce IO Waits in SQL Server: Read the Waits First
To reduce IO waits in SQL Server, first name the wait. This post explains the main IO wait types and measures two of them for a single session on a demo database. It then shows how to check file latency and which fix matches each wait.
Finding the Plan That Changed: Query Store Plan History
Read Query Store plan history, compare duration by interval, find plan changes, and review a temporary force with an exit plan.
When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207
When should you use sort_in_tempdb for rebuilding indexes? A DBA asked me in a Health Check, and the simple answer is when TempDB sits on fast, separate drives.