12/08/2014 6:55:48 AM
Stored procedures are used in almost every application. However, not every stored procedure is used the same way and with the same parameters each time. As a result, you might see inconsistent performance and even tremendously poor performance under the "right" conditions. Why? Because your procedure is sensitive to the parameters used but the plan does not change for each execution. But, do you want it to change for EVERY execution? Recompiling every time is too costly. So, how do you solve this problem and balance performance and CPU? Attend this session to find out!
About the Speaker
Kimberly L. Tripp is a SQL Server MVP and a Microsoft Regional Director and has worked with SQL Server since 1990. Since 1995, Kimberly has worked as a Speaker, Writer, Trainer and Consultant for her company SYSolutions, Inc. (www.SQLskills.com), which she runs with her husband, Paul S. Randal. Kimberly also owns and runs the SQLintersection conference series, and co-teaches the highly popular SQLskills Immersion Event series of classes. Since SQL Server 2000, she has co-authored titles such as SQL Server 2000 High Availability, the SQL Server 2000 Resource Kit, SQL Server 2008 Internals and SQL Server MVP Deep Dives and spoken at numerous conferences such as SQLintersection, SQLPASS, and many TechEd events around the world, where she is consistently a top rated speaker. Prior to starting SYSolutions, Kimberly held positions at Microsoft including Subject Matter Expert/Trainer for Microsoft University and Technical Writer for the SQL Server Development Team.
Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:45pm finish |
On: Tuesday, 16 September 2014