SQL Server: Troubleshooting Query Plan Quality Issues (2013)
English | WMV | 1024 x 768 | WMV3 ~223 kbps | 15 fps
WMA | 128 Kbps | 44.1 KHz | 2 channels | 2h 20mn | 396 MB
Genre: Video Tutorial / Programming
Learn how to identify, diagnose, and prevent problems where SQL Server chooses the incorrect query plan for your critical queries, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards. There 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.