Blog

A Slightly Different Parameter Sensitivity Problem

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…

Read the post: A Slightly Different Parameter Sensitivity Problem

SQL Server Performance Office Hours Episode 95

SQL Server Performance Office Hours Episode 95 To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:04:52 – Resource Semaphore and Blocking 00:05:46 – Plan Forcing Hazards 00:07:20 – Why TOP N Queries Run Slower 00:09:15 – Worker…

Read the post: SQL Server Performance Office Hours Episode 95

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 – Introduction…

Read the post: SQL Server Performance Consulting for the AI Era