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. 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.