A reader asked how to fix Cannot drop the assembly ‘ISSERVER’ without another SQL Server to generate the script from. Here is a second way to fix this upgrade error.
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.
Scheduling Recurring Events: Every Second Tuesday in T-SQL
Generate recurring events with stable weekday arithmetic, monthly ranking, and anchored fourteen-day rules instead of endless date rows.
SQL SERVER – Enabling Older Legacy Cardinality Estimation
Legacy Cardinality Estimation temporarily stabilized one customer memory-grant problem. A query waited on RESOURCE_SEMAPHORE while the instance became unresponsive.