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.
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.
Current Language of a SQL Server Session: How to Check It
To find the current language of a SQL Server session, read @@LANGUAGE or @@LANGID, or query sys.dm_exec_sessions. This post tests each one, switches the session to German and British, and shows how the language changes month names and how text turns into dates.
Visual Studio – FIX: The ‘SqlStudio Profile Package’ Package Did Not Load Correctly
Launching Visual Studio on my VM failed with: The ‘SqlStudio Profile Package’ package did not load correctly. I gathered a list of fixes that can solve it.