Statistics for the New Data Pro (Grant Fritchey)

in SQL Server

Tuesday, September 8, 2015, 6:00 PM to 8:30 PM


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.

Speaker Bio:
Grant Fritchey has more than twenty years’ experience in IT in development and database administration. He is a Red Gate Software Product Evangelist. He writes articles for SQL Server Central and Simple-Talk. He is the author of “SQL Server Execution and “SQL Server Query Performance Tuning” and co-author of “SQL Server MVP Deep Dives 2″, “Beginning SQL Server 2012 Administration” and “Pro SQL Server 2012 Practices.” Grant is one of the founding officers of the Southern New England SQL Server Users Group and currently serves on the PASS Board of Directors in charge of Chapters. He presents at conferences and user groups around the world and is a Microsoft SQL Server MVP and a Dunn & Bradstreet MVP. He has called rough, intimidating and scary. To which he usually reply, “Good.”

Leave a Comment

Previous post: