RunAs Radio

Query Performance Tuning Strategies with Monica Rathbun


Listen Later

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!
...more
View all episodesView all episodes
Download on the App Store

RunAs RadioBy Richard Campbell

  • 4.6
  • 4.6
  • 4.6
  • 4.6
  • 4.6

4.6

82 ratings


More shows like RunAs Radio

View all
Software Engineering Radio - the podcast for professional software developers by team@se-radio.net (SE-Radio Team)

Software Engineering Radio - the podcast for professional software developers

271 Listeners

Hanselminutes with Scott Hanselman by Scott Hanselman

Hanselminutes with Scott Hanselman

383 Listeners

.NET Rocks! by Carl Franklin and Richard Campbell

.NET Rocks!

37 Listeners

The Changelog: Software Development, Open Source by Changelog Media

The Changelog: Software Development, Open Source

290 Listeners

This Week in Tech (Audio) by TWiT

This Week in Tech (Audio)

3,062 Listeners

Security Now (Audio) by TWiT

Security Now (Audio)

2,010 Listeners

MacBreak Weekly (Audio) by TWiT

MacBreak Weekly (Audio)

2,011 Listeners

Windows Weekly (Audio) by TWiT

Windows Weekly (Audio)

887 Listeners

Tech News Weekly (Audio) by TWiT

Tech News Weekly (Audio)

1,073 Listeners

Intelligent Machines (Audio) by TWiT

Intelligent Machines (Audio)

780 Listeners

The a16z Show by Andreessen Horowitz

The a16z Show

1,091 Listeners

Daily Tech News Show by Tom Merritt

Daily Tech News Show

1,393 Listeners

Smashing Security by Graham Cluley

Smashing Security

319 Listeners

.NET Rocks! by Carl Franklin and Richard Campbell

.NET Rocks!

244 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

63 Listeners

2.5 Admins by The Late Night Linux Family

2.5 Admins

98 Listeners