SQL Performance Optimization

Video Title :	SQL Performance Optimization
Description :	Gain insight into best practices for SQL Server optimization and ways to alleviate many root causes that can impact performance of your SQL Server database. Kevin also will discuss how to manage for planned and unplanned changes, speed time to implementation of your applications and ensure that your databases are running as they should. You will learn how to: * Identify the root cause of bottlenecks that hinder performance of your SQL Server environment * Diagnose and fix T-SQL errors in development before code goes into production * Learn new best practices for project planning and formatting your code * Ensure that your code is scalable, optimized and validated * Resolve 60-80% of the performance bottlenecks attributed to poorly written SQL
Views :	12476
Rating :	4.62
Keywords, Tags :	quest software sqlserver sql server optimization kevin kline mvp microsoft t-sql database
Video Length :	45 : 58

Comments :

v good

Thanks, very helpful information.

Covers: Subquery vs Joins, Union vs Union ALL, Top & Set Rowcount commands, Delete From and Update From usage, Set NoCount On and Off commands - little bit details on Query execution plans

Thank you for posting. Quite rare to find such video lesson on the web.