DBCC DBREINDEX still runs on SQL Server 2025, but it is deprecated, and ALTER INDEX does everything it did and more. This post rebuilds a fragmented demo table both ways, shows the options only ALTER INDEX has, and finds old uses of DBCC DBREINDEX in your own modules, Agent jobs and the deprecation counter.
Deprecated System Tables: Replacing sysobjects and sysindexes
Old catalog views still answer, but their page counts can be far too small. A short demo shows the gap and how to replace them.
How to Check Edition Specific Features Enabled In SQL Server? – Interview Question of the Week #180
Moving databases to another edition? Here is a simple script for SQL Server 2008 and later that lists the Edition specific features each database uses.
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.
SQL Server – Knowing the Use of Deprecated or Discontinued Features
After an upgrade, a DBA’s management asked if any deprecated or discontinued features were still in use. Here is how to find that out on a live server.
Attach a Database in SQL Server and Detach It Safely
To attach a database, use CREATE DATABASE with FOR ATTACH and point it at the data and log files. This post detaches a demo database, attaches it again, shows the error that stops a detach, and compares the old sp_attach_db procedure with the current statement.