Database diagram support objects cannot be installed on a database upgraded from SQL Server 2005? This time the fix was the compatibility level.
INNER HASH JOIN: Why a Table Join Hint Also Fixes Join Order
A join hint in the FROM clause quietly fixes the join order. I show the warning, three plans side by side, and the softer query-level alternative.
Checking XML Index Size Against the Table It Belongs To
An XML index can outweigh the table it serves. Here is how I measure each XML structure next to the base table, and what to test before dropping one.
Updatable Views: When INSERT and UPDATE Work Through a View
A view is only a doorway to the table behind it. I show which writes get through, which get rejected, and why CHECK OPTION earns its place.
ALTER TABLE REBUILD: Fixing a Heap Without a Clustered Index
A heap with widening rows collects forwarded records. Here is how to measure them, fix them and know when the fix will not last.
Explicit Identity Values: Loading Rows With Their Old Keys
Moving rows and keeping their old keys? Here is the safe order of steps, and the counter check that saves you from a collision.
Comparing Session SET Options Between SSMS and the Application
Fast in SSMS, slow in the app? The query may be fine and the connection settings different. Here is how to check, with nothing to set up.