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. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.