Good Citizen
Here are some interesting questions that I’ve answered on dba.stackexchange.com:
- Creating tempdb contention in SQL Server
- Conditional summing
- Is IN always an equality search?
- When to use loops in a database
- Counting occurrences with a left join
- SQL Server memory usage
- Why is this stored procedure slow?
- Different query plans for CTEs and temp tables
- Object names in dynamic SQL
- Why isn’t my loop finishing?
- Where can columns in subqueries be referenced?
- Tuning queries to avoid deadlocks
- EXISTS vs CROSS JOIN
- Speeding up REPLACE query on a large table
- Slow query response with spatial column data
- Join performance with user defined table types
- Why is this SELECT * query faster?
- Optimizing a query with a large aggregation
- Why are CTEs totally oversold as performance enhancements?
- Will NOLOCK make my queries faster?
- Scalar UDFs in check constraints
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.