Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
After tempdb, msdb is often the most abused system database, growing unchecked until it tanks...
2026-02-11 (first published: 2026-01-30)
469 reads
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
If you’ve spent any time tuning SQL Server, you’ve probably heard “Turn...
2026-02-09 (first published: 2026-01-27)
306 reads
Dry-run xp_delete_file Before Actually Deleting Files?
xp_delete_file doesn’t really have a built-in dry-run option to preview which files it would remove. But there’s a simple workaround,...
2025-12-10 (first published: 2025-11-27)
470 reads
Writing Better Dynamic SQL
This updated and "sort" of a style guide is for SQL developers and, to some extent, DBAs, essentially anyone daring (and sometimes...
2025-11-18
290 reads
Set Theory vs. Batch Mode in SQL Server
Not long ago, a colleague of mine was completely shocked when he first heard about SQL Server’s Batch Mode feature. His immediate...
2025-10-15 (first published: 2025-09-23)
582 reads
Measuring and Improving SQL Server Query Plan Cache Efficiency
The query plan cache hit ratio in SQL Server indicates the percentage of queries that are executed...
2025-07-11 (first published: 2025-06-24)
629 reads
15 Characters or Less: The Challenge of SQL Server Listeners Name
There is a hard limit on how long your AlwaysOn listener name can be. That...
2025-01-27 (first published: 2025-01-14)
369 reads
How to clear the SSMS cache?
If you are reading this, it's probably because you too have this rare need to clear the SSMS cache for...
2025-01-13 (first published: 2025-01-10)
2,526 reads
How to Find Where Your Databases Reside In The File System
SQL Script:
Copy
/*
RETURNS LIST OF FOLDER NAMES WHERE SQL SERVER DATABASE
FILES ARE STORED.
It is dynamic...
2024-12-27 (first published: 2024-01-31)
793 reads
Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database
As one of the preventive database maintenance tasks, performing database integrity checks on almost every database you...
2024-07-01 (first published: 2024-06-13)
555 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers