Query Performance Tuning Strategies with Monica Rathbun
How do you keep your SQL queries fast? Richard chats with Monica Rathbun about her approaches to SQL Server query tuning. Monica starts with defining the problem - how do we know that the database is the performance bottleneck? The conversation dives into measuring query performance and the power of Query Store, but only on SQL Server 2016 and above, so get upgrading! Entity Framework is a standard tool for developers to automate access to SQL. Still, it can generate some pretty ugly queries, and Monica talks about different ways to improve them, including the old standby of writing a stored procedure. Lots of ideas for folks struggling to make their databases go fast!
Episode 823 of the RunAs Radio podcast, hosted by Monica Rathbun, Richard Campbell, titled "Query Performance Tuning Strategies with Monica Rathbun" was published on April 13, 2022 and runs 36 minutes.
April 13, 2022 ·36m · RunAs Radio
Summary
How do you keep your SQL queries fast? Richard chats with Monica Rathbun about her approaches to SQL Server query tuning. Monica starts with defining the problem - how do we know that the database is the performance bottleneck? The conversation dives into measuring query performance and the power of Query Store, but only on SQL Server 2016 and above, so get upgrading! Entity Framework is a standard tool for developers to automate access to SQL. Still, it can generate some pretty ugly queries, and Monica talks about different ways to improve them, including the old standby of writing a stored procedure. Lots of ideas for folks struggling to make their databases go fast!
Episode Description
How do you keep your SQL queries fast? Richard chats with Monica Rathbun about her approaches to SQL Server query tuning. Monica starts with defining the problem - how do we know that the database is the performance bottleneck? The conversation dives into measuring query performance and the power of Query Store, but only on SQL Server 2016 and above, so get upgrading! Entity Framework is a standard tool for developers to automate access to SQL. Still, it can generate some pretty ugly queries, and Monica talks about different ways to improve them, including the old standby of writing a stored procedure. Lots of ideas for folks struggling to make their databases go fast!
Links:
- Monitoring Performance with Query Store
- Common Table Expressions
- Cursors in SQL Server
- SQL Server Profiler
- Glenn's SQL Server Performance Blog
Recorded February 22, 2022
Similar Episodes
Apr 10, 2026 ·62m
Apr 9, 2026 ·101m
Apr 8, 2026 ·21m
Apr 7, 2026 ·52m
Apr 3, 2026 ·63m