Microsoft SQL Server Execution Plans: From Compilation, to Caching, to Reuse
Description
You’ve heard it before: “It worked fine on my machine, but the users say it’s too slow.” Don’t blame the developers: they’re using SQL Server features that look great on paper, but in reality, they won’t scale up to production loads. Learn to recognize these common mistakes before they go into production, and be armed with easy fixes.
Share
Download
Download this episode
- High Quality MP4 (31.6 MB)
- Mid Quality WMV (83.8 MB)
- High Quality WMV (180.5 MB)
For more information, check out this course on Microsoft Virtual Academy:
Event Homepage
Tech·Ed North America 2010More episodes in this series
The Total Noob’s Guide Windows Workflow Foundation 4
Related episodes
Blocking: How to Find and Fight LCK* Waits
Watch Brent Tune Queries
Identifying and Fixing Parameter Sniffing
Microsoft SQL Server Performance Tuning: Live
Microsoft SQL Server Unplugged
Microsoft SQL Server 2014 Private and Hybrid Cloud Features
Private Cloud - Better Together: Microsoft SQL Server 2012, Windows Server 2012 and System…
Building the Fastest Microsoft SQL Servers
Building the Fastest SQL Servers
Microsoft SQL Server in Virtualization and Private Cloud
