
Sign up to save your podcasts
Or


How do you make your SQL queries go faster? Richard chats with Erin Stellato about how Query Store in SQL Server 2017 and its ability to provide detailed information on query performance, including where SQL Server is compiling new query plans for repeated calls. Erin talks about how ORMs can cause repeated ad-hoc queries and how Query Store can be used to help educate developers and explore options for tuning those queries with stored procedures or parameterization. But you can't blame code by default - Query Store can be used for a variety of performance tuning options, on-premises and in the cloud!
By Richard Campbell4.6
8282 ratings
How do you make your SQL queries go faster? Richard chats with Erin Stellato about how Query Store in SQL Server 2017 and its ability to provide detailed information on query performance, including where SQL Server is compiling new query plans for repeated calls. Erin talks about how ORMs can cause repeated ad-hoc queries and how Query Store can be used to help educate developers and explore options for tuning those queries with stored procedures or parameterization. But you can't blame code by default - Query Store can be used for a variety of performance tuning options, on-premises and in the cloud!

272 Listeners

383 Listeners

38 Listeners

290 Listeners

3,062 Listeners

2,008 Listeners

2,012 Listeners

887 Listeners

1,072 Listeners

780 Listeners

1,095 Listeners

1,394 Listeners

319 Listeners

245 Listeners

63 Listeners

98 Listeners