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.
Error 18210: New Parallel Operation Cannot Be Started During Backups
Error 18210 showed up in a client’s ERRORLOG beside a message that a new parallel operation could not be started. The client’s third-party tool backed up more than 1,000 databases at the same time. Staggering the backups stopped the error.
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 – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You do not Have Permission
An upgrade could not start SQL Server: Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission. Here is another way to fix it.
What is Consolidation of Index? – Interview Question of the Week #212
What is consolidation of index? When a table has overlapping indexes, like one on Col1 and one on Col1, Col2, here is how I think about combining them.
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.