We've had a speaker change! Grant Fritchey (@gfritchey (http://twitter.com/gfritchey)) will be presenting 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.
Grant Fritchey (http://www.scarydba.com/) is a SQL Server MVP (https://mvp.microsoft.com/en-us/PublicProfile/4025126?fullName=Grant%20Fritchey) 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 (http://www.red-gate.com/) as a product evangelist in January 2011.
Before our main speaker, Andy Mallon (@AMTwo (http://twitter.com/AMTwo)) will be presenting a lightning talk on SSMS Shortcuts.