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.
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.
Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211
Do parallel threads process equal rows? Usually no, and a simple AdventureWorks query with its actual execution plan proves it in a few seconds.
What is Trusted Constraint in SQL Server? – Interview Question of the Week #210
What is a trusted constraint in SQL Server? Many experts do not know, so instead of a definition I explain it with a simple check constraint example.






