
Sign up to save your podcasts
Or
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:
Recorded February 22, 2022
4.6
8080 ratings
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:
Recorded February 22, 2022
3,012 Listeners
1,981 Listeners
377 Listeners
272 Listeners
37 Listeners
244 Listeners
2,011 Listeners
868 Listeners
364 Listeners
640 Listeners
734 Listeners
283 Listeners
1,072 Listeners
154 Listeners
63 Listeners
91 Listeners