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.
Eager Index Spool: When the Plan Builds Its Own Index
Investigate an eager index spool, read seek keys and output, and compare a supporting index with the cost of rebuilding temporary storage.
SQL SERVER – Upgrade Error – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You Do Not Have Permission
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.
SQL SERVER – How to Invoke SSMS Help From Command Prompt?
A workshop attendee asked how to invoke SSMS help from Command Prompt. Here is how to open SSMS from the command line and list all of its parameters.
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.
SQL SERVER – New Parallel Operation Cannot be Started Due to Too Many Parallel Operations Executing at this Time
A client’s ERRORLOG said: New parallel operation cannot be started due to too many parallel operations executing at this time. Here is what I found behind it.