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)
454 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
287 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)
577 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)
603 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,253 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)
750 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)
546 reads
Search and Export Script for SQL Server Databases
Plainly speaking, this article is about searching for a specific value inside all tables and their columns of a SQL database and...
2024-04-24 (first published: 2024-04-09)
590 reads
Finding the Latest Backup Timestamps for Your Databases
I wanted to find out the most recent date and time each database was last backed up, focusing specifically on full, differential,...
2024-04-08 (first published: 2024-03-29)
563 reads
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I was messing around performing investigative work on a pod running SQL Server 2025...
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Comments posted to this topic are about the item What is Page Density
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Looking to confirm my understanding of these three products and how they can be...
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers