How and when lock escalation is triggered in SQL Server. Spoiler: it doesn't happen at 5000 locks. sqlperformance.com/2022/09/sql-pe…

Paul White Great idea! Revised.

The second instalment in my SQL Server lock escalation series, featuring: 🔹 A scan escalating some locks, but not others 🔹 179 escalation attempts scanning a 15-page heap sqlperformance.com/2022/10/sql-pe…

Weird problems deserve weird blog posts. forrestmcdaniel.com/2022/10/11/a-d…

🌟Today's Microsoft Learn Contributor Spotlight: Tom Zíka is a Sr. Database Engineer, who specializes in performance tuning and SQL optimization. 👉 aka.ms/contributor-st… #MicrosoftLearnContributor #ContributorStories

If you're running SQL Server 2022, hold off installing CU4 if you're using the Parameter Sensitive Plan Optimization with Query Store on, OR if you have indexes with a descending order key and you like your ORDER BY clauses to work properly. If you've already installed CU4, turn

📬 T-SQL Tuesday: Code That Made You Feel A Way: ift.tt/zqjyuOE 📬

Community captions requested:

New SQL Server blog entry: Why Batch Mode Sort Spills Are So Slow (sql.kiwi)

Ten months ago, we launched the Vesuvius Challenge to solve the ancient problem of the Herculaneum Papyri, a library of scrolls that were flash-fried by the eruption of Mount Vesuvius in 79 AD. Today we are overjoyed to announce that our crazy project has succeeded. After 2000

A short new post: forrestmcdaniel.com/2024/06/12/sol…

I found columnstore key lookups were a lot slower than regular key lookups, and wanted to figure out why: forrestmcdaniel.com/2024/08/05/why…

Woah, 10 years today of working with SQL Server. Many thanks to the many people who have helped me along the way.

This needs votes: zoom results in SSMS developercommunity.visualstudio.com/t/Zoom-the-res…