Grant Fritchey, renown SQL Server Author/Presenter, is our remote speaker. Grant is a former SQL Server MVP and writes articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. he has published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” He is one of the founding officers of the Southern New England SQL Server Users Group and it’s current president. When not slaving away over books or at Red Gate. Grant also work on part-time, short-term, off-site consulting contracts.
Seven Ways To Fix Bad Parameter Sniffing and will cover:
Parameter sniffing is a misunderstood issue on SQL Server. Most of the time parameter sniffing is helping performance on your servers. But sometimes, circumstances change and what was helping you is now hurting you, bad. In this session we’ll gain an understanding of what exactly parameter sniffing is and why it’s usually so helpful. Then, we’ll explore how parameter sniffing can go wrong and I’ll show you seven different ways you can deal with it when it does. You’ll bring back a wealth of knowledge so that you can identify and resolve bad parameter sniffing in your own environment.