After a cluster rebuild, adding a replica failed: The specified instance is hosted by a system that is not a Windows Server Failover Cluster node. Here is the fix.
Hypothetical Indexes in SQL Server: Find and Drop Them All
Hypothetical indexes are leftovers from the Database Engine Tuning Advisor. They hold a name and statistics but no data. This post lists them, shows they cannot serve a query, and drops them in two steps: a list you read first, and a drop second.
How to Extract Alphanumeric Only From A String? – Interview Question of the Week #214
A reader wanted only the values that mix letters and numbers from a column. Here is how to extract alphanumeric values from a string with simple pattern matching.
Index Key Columns and Included Columns in SQL Server
Index key columns and included columns show what each index really stores. This post builds one query that lists them for every index, then a second query that finds indexes with the same keys or a shared leading key. It ends with the rules for merging them safely.
SQL SERVER – Windows Authentication or System Admin Account (SA)
Windows Authentication or the SA account? A client asked me in a Health Check, and here is why my advice is Windows Authentication wherever you can.
How to Find Table Cardinality from the Execution Plan? – Interview Question of the Week #213
How to find table cardinality from the execution plan? I answer this health check question in two different ways, using a simple AdventureWorks query.
Update Statistics With FULLSCAN and MAXDOP in SQL Server
To update statistics with FULLSCAN in parallel, add MAXDOP to the statement. This post builds a table of 3 million rows, times the update with MAXDOP 1, the instance default and 8, and shows which statistics speed up and which do not.






