Good Citizen
Here are some interesting questions that I’ve answered on dba.stackexchange.com:
- Why don’t some queries have parameter values in query plans
- Recreating tempdb contention
- Why is Microsoft’s documentation about parallelism wrong?
- What’s wrong with my stored procedure?
- How should I analyze historical waits?
- Why doesn’t my Heap have a name?
- Of Sorts And Merges
- Disabling CEIP
- Why are my CPU cores offline?
- How do I corrupt a database?
- Optimizing joins
- Why is my query slow?
- TOP N Sort
- Shared resources: Bad?
- Does my plan cache need a probiotic?
- How do I deal with a massive number of vulnerabilities?
- Cardinality estimation model vs. Database compatibility level
- A shocking reason for bad query performance
- Stored procedure names in the plan cache
- Too many dupes on the dance floor
- Why do missing index recommendations suck?
- Why is RAISERROR so cool?
- Temporary stored procedures are great
- What causes recompilation?
- Another shocking reason for a slow query
I should probably get a real job.
Thanks for reading!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.