The primary key and the clustered index are two different jobs. This demo keeps the GUID as the public ID and clusters on an identity column instead.
What Is a View in SQL Server?
A view in SQL Server is a saved query, not a saved copy. Nothing is stored, the text is run every time, and that single fact explains what a view is good for and why it never makes anything faster.
Cleaning Up Ownership Before Dropping a Departed User
DROP USER fails when the user still owns a schema, a role or a table. Here is how to find those owners and hand them over safely.
Finding Deprecated Features Before They Bite
Find deprecated features with SQL Server counters, event metadata, and code searches, then separate future risk from features already removed.
Indexing Basics Course: Learning SQL Server Performance
Vinod Kumar and I released an indexing basics course in 2012. This post keeps the original outline and cartoon, and adds tests on SQL Server 2025 for four of its practical topics: column order, functions on indexed columns, filtered indexes and disabled indexes.
T-SQL Errors and Reactions Demo: SQL in Sixty Seconds #005
This T-SQL errors and reactions demo follows episode #002 with queries you can run. It shows what a CATCH block can read, how severity is stored, how to log a failure and keep going, and why THROW keeps the original error while RAISERROR replaces it.
Optimized Plan Forcing: Cutting Compile Time in SQL Server 2022
Check optimized plan forcing in SQL Server 2022 through scoped configuration and Query Store replay flags, then compare compile duration.