12:30 sharp start
12:30 - 12:31 Welcome and hello
12:31 - 13:30 Remote Presentation : Kimberly Tripp
Statement Execution, Plan Cache Bloat and Parameter Sniffing – What does it all mean?
When you execute a statement, it’s optimized and cached, right? Well, maybe… There are different ways to execute code: adhoc statements, dynamic string execution, sp_executesql, batches, and procedures. Do they all behave the same way? Are there benefits to one over the other? Absolutely! And, that’s the point of this session – to demystify the plan cache and tell you the pros and cons of different types of coding practices. In the end, you’ll be able to understand your options and know the best one to use based on your data. If you execute any code in SQL Server, you must understand this or you will have problems!
Kimberly has been a Microsoft SQL Server MVP and a Microsoft Regional Director for over 10 years; she’s an author, consultant and top-rated speaker having spoken at PASS, TechEd, VSLive and numerous other events around the world. She has over 20 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies and partitioning. When she's not tuning SQL servers, she's probably diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.
Microsoft SQL Server MVP since 2002