A Slightly Different Parameter Sensitivity Problem Chapters 00:00:00 – Introduction 00:03:24 – A Demo Claude Wrote 00:05:19 – Fast Plans With Recompile 00:06:23 – Compiling for Vote Type ID 4 First 00:08:11 – When the Other Index Gets Compiled First 00:09:44 – How to Fix It…
Badges
Badges come from GitHub once the author claims this feed.
Recent posts
every link opens the author’s post-
A Slightly Different Parameter Sensitivity Problem
-
Mind Your Darn Aliases
Mind Your Darn Aliases Chapters 00:00:00 – Introduction 00:04:30 – Query Analysis 00:05:20 – Unusual Query Plan 00:06:39 – Correct Aliasing 00:08:16 – Wrap-Up Full Transcript Erik Darling here with Darling Data, and today’s video is a bit of a public service announcement.
-
SQL Server Performance Office Hours Episode 95
SQL Server Performance Office Hours Episode 95 To ask your questions, head over here.
-
Come Hang Out In Boston: Nobody Wants To Tune Queries By Hand Anymore
I’m coming up to the Boston area on Friday, April 9, 2027 to teach a full day, hands-on workshop, and my friend Vlad and NESQL are hosting it at Microsoft in Burlington.
-
SQL Server Performance Consulting for the AI Era
SQL Server Performance Consulting for the AI Era AI for Database Teams is a one-day workshop, on-site or remote, that teaches your developers and DBAs to work with AI agents on your own SQL Servers: training.erikdarling.com/ai-for-database-teams-workshop Chapters 00:00:00 –…
-
How SQL Server People Can Stay Relevant With AI
How SQL Server People Can Stay Relevant With AI Chapters 00:00:00 – Introduction 00:02:28 – Query Plan Analyzer Tool 00:04:55 – Robot Setup and Automation 00:07:20 – Idea Implementation and Execution 00:09:24 – Conclusion Full Transcript Erik Darling here with Darling Data.
-
SQL Server Performance Office Hours Episode 94
SQL Server Performance Office Hours Episode 94 To ask your questions, head over here.
-
Key Lookups and Index Creation
Key Lookups and Index Creation Chapters 00:00:00 – Introduction 00:01:30 – Index Creation and Key Lookups 00:04:28 – Query Plan Analysis 00:06:45 – Outdated Statistics Impact 00:09:16 – Key Lookup During Index Creation Full Transcript Erik Darling here with Darling Data… that…
-
DOP and Tipping Points In SQL Server
DOP and Tipping Points In SQL Server Chapters 00:00:00 – Introduction 00:01:05 – DOPing Points Explained 00:03:20 – Query Cost Analysis 00:05:50 – Tipping Points and DOP 00:07:35 – Conclusion Full Transcript Erik Darling here with Darling Data.
-
SQL Server Performance Office Hours Episode 93
SQL Server Performance Office Hours Episode 93 To ask your questions, head over here.
-
The Joys of Early Exits
The Joys of Early Exits Chapters 00:00:00 – Introduction 00:01:31 – Early Exits in Code 00:04:13 – Practical Examples 00:06:00 – Early Exits in Triggers 00:08:06 – Benefits of Early Exits 00:08:37 – Conclusion Full Transcript Erik Darling here with Darling Data.
-
How I Use Claude Code to Build Stuff
How I Use Claude Code to Build Stuff Chapters 00:00:00 – Introduction and Setup 00:02:30 – Opus and Fable Usage 00:06:00 – Agent Management and Token Usage 00:08:30 – Example Workflow with Opus 00:11:00 – Setup and Tools Overview 00:12:30 – Monitoring and Complex Projects Full…
-
SQL Server Performance Office Hours Episode 92
SQL Server Performance Office Hours Episode 92 To ask your questions, head over here.
-
The Perils of Secondary Metrics in SQL Server
The Perils of Secondary Metrics in SQL Server Chapters 00:00:00 – Introduction 00:02:38 – Index Fragmentation 00:05:19 – Fill Factor Misconceptions 00:07:45 – Missing Index Requests 00:10:37 – Wait Stats and CXPACKET Waits 00:13:26 – Global Settings and Query Optimization…