At least 80% of all database performance problems can be related directly to your T-SQL code and your data structures. This full-day workshop gets right to the heart of that issue and shows you how to identify common performance problems using the tools available to you within SQL Server.
With the problems identified, we then proceed to figure out how to address those problems using execution plans to understand the choices made by the query optimizer. You’ll learn multiple ways to capture execution plans, how to interpret them, and how to query them directly. All the examples and scripts will be immediately applicable to your systems. You can address your performance problems in order to make your T-SQL code run faster.
About Grant Fritchey...
Grant is an active participant in the SQL Server Central discussion forums. He writes articles for SQL Server Central and Simple-Talk. He blogs regularly at scarydba.com. Grant is the author of the books "SQL Server Query Performance Tuning" and "SQL Server Execution Plans." He is co-author on the books "SQL Server MVP Deep Dives 2," "Beginning SQL Server 2012 Administration," "Pro SQL Server 2012 Practices," and "Expert Performance Indexing in SQL Server." Grant Fritchey works for Red Gate Software as a Product Evangelist. Grant has 20 years experience in the industry as a DBA and developer. Grant volunteers for the Professional Association of SQL Server Users (PASS) currently serving on the Board of Directors as the Executive Vice President. Grant's nickname is "The Scary DBA."