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: these days I have AI do the annoying stuff for me. My new video course teaches you to work the same way, and I teach whole teams in a one-day workshop. Someone still has to know enough SQL Server to keep the robots in check, and that’s what my training is for.