Pluralsight blog Where devs, IT admins & creative pros go for news, tips, videos and more.
Pluralsight + Digital-Tutors - 3,000 tech & creative courses - starting at $29/month Get it now →
January 11, 2013

New Course: SQL Server: Troubleshooting Query Plan Quality Issues

By

Joe Sack of SQLskills has just published a new course: SQL Server: Troubleshooting Query Plan Quality Issues

sqlserver-cpipThere are many problems that can lower the performance of your workload and one of the most common is an incorrect query plan. Often the poor query plan is chosen because the cardinality estimate is wrong – the estimate by the query processor of how many table rows will be involved in the query. Joe does a great job at showing you how to recognize when the query processor has an incorrect estimate, along with explaining and showing a multitude of possible causes, plus how to fix them.

This course is perfect for developers, DBAs, and anyone responsible for performance tuning on SQL Server. The information in the course applies to all version from SQL Server 2005 onwards.

Click here and enjoy the course now

About the Author


Discussion