Statistics for the New Data Pro
Many performance tuning methods can get your queries to run faster. But the most important thing you can do to improve query performance is to ensure that you have provided the query optimizer within SQL Server with the best possible statistics. This session teaches you what statistics are, how they are generated, and their use within the optimizer. You can take home a better understanding of how the optimizer works with statistics, to write better T-SQL and build better database structures to avoid common issues such as bad parameter sniffing. Help the optimizer help you by maintaining your statistics and get improved query performance.
About the Presenter
Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Red Gate Software as a product evangelist in January 2011.
This event is hosted by the Adelaide SQL Server User Group, and sponsored by LobsterPot Solutions
Join millions of people on Eventbrite.
In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.