The query optimizer has never given an interview. It made time on a Sunday evening, answered everything, apologised for nothing,…
Browsing: SQL
IntroductionI was experimenting with vector search in SQL Server 2025 using approximately 3.8 million Hacker News articles that that I…
Welcome to the SQL Advisor, where the answer is never “it depends” unless I tell you what it depends on.…
Fiction. The understudy is the person paid to stay ready, and this is what that job looks like from the…
Wait types are the most misread numbers in SQL Server. So I caused six of them on purpose, one at…
AI in production without a second pair of eyes is a quick way to lose a table. Cardinal was going…
Deadlock or just a queue? Three sessions are waiting. Name the two stuck together without blaming the third.A waiting session…
AI productivity gains went up on every dashboard I’ve seen. I’ve watched teams double the code they produce. I’ve watched…
A GUID primary key can solve a real application problem. Making a random GUID the clustered key also makes a…
Part three of ten. A wrong answer from a model sounds exactly like a right one. That single fact explains…