August 18th, 2015
Stored Execution Plans – The good, The Bad and The Ugly
Brandon Brown, Crowe Horwath
Have you ever wondered why a procedure will run quickly one minute and slow the next? Without in-depth knowledge of execution plans, understanding performance variances can be a very painful experience. Sometimes stored execution plans can beneficial and other times it can lead to major performance degradation. I am going to show examples of how I use stored execution plans to performance tune our applications. I will cover topics such as parameter sniffing, incorrect temp table statistics, and statistic utilization within plans.
My name is Brandon Brown. I am a SQL developer / DBA in Indianapolis, IN. I have spent most of my career building healthcare applications for reporting and data analytics. Over the years I have become infatuated with the SQL query optimizer, execution plans, and performance.
5:30 - Professional Networking & Food
6:00 - Announcements
6:15 - Featured Presentation
7:15 - Prize Drawings
1401 North Meridian St.
Indianapolis, IN 46202