Use DROP_EXISTING to change an index definition in one operation, inspect its columns, and check online availability and dependencies.
SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST
A Saturday fun puzzle with DATETIME2 and CAST in SQL Server 2012. Run each script one at a time, guess the output, and learn something new.
Deprecated Features and Breaking Changes: Plan Your Upgrade
Breaking Changes are only one of four kinds of change that an upgrade brings. This guest post by Nakul Vachhrajani explains the four kinds, how to find deprecated feature use with Extended Events and the Deprecated Features counters, and a checklist for planning the upgrade.
Upgrading With Log Shipping for a Short Cutover
Upgrading with log shipping stages a newer secondary with NORECOVERY, applies logs in order, and leaves a short, rehearsed final cutover.
SQL Server Lessons: Five Short Scripts You Can Run in a Minute
SQL Server lessons stick when you can run them in a minute. This page covers errors, security, XML, hierarchies and query hints. Each lesson asks one question and answers it with a short script. Every result comes from SQL Server 2025.
SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME
Many people join sys.tables and sys.schemas to get a schema name from an object ID. The OBJECT_SCHEMA_NAME function does it in one simple call.
SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats
My Columnstore index DMV script failed on SQL Server 2012 RTM because sys.column_store_index_stats was gone. What I found next, with sys.dm_db_index_usage_stats.
Columnstore Indexes for Reporting Tables
Columnstore indexes for reporting tables can cut scan work, but clustered and nonclustered designs affect loading and point lookups differently.
Filling Template Parameters in SSMS With Ctrl+Shift+M
Template parameters save you from typing one value in four places, but they only paste text. Here is what that means in practice.
XML modify(): Inserting, Replacing and Deleting Nodes
The modify() method edits XML in place, but a path that matches nothing changes nothing and says nothing. Here is how to stay in control.










