Fox Valley Microsoft Data Platform

Next Meeting: Wed, Oct 04 2017

FoxPass October 2017 Meeting

Language: English
Event Type: In-Person & Online
Online Meeting URL: None

FoxPass October 2017 Meeting


UTC : Wed, Oct 04 2017 22:30 - 00:30
Event Time : Wed, Oct 04 2017 17:30 - 19:30 Central Daylight Time
Your Local Time: Wed, Oct 04 2017 22:30 - 00:30


100 W Lawrence St, Suite 100 Appleton Center
Appleton, Wisconsin

Direction: None

Featured Presentation

Why is the Same Query Sometimes Slow?

Speaker: Brent Ozar, Microsoft Certified Master of SQL Server Brent Ozar Unlimited

Summary: You swear nothing has changed, but all of a sudden, out of nowhere, queries that used to be fast are suddenly slow. Even weirder, you take the slow query from the application, run it in SSMS, and it's totally fast! What's going on? You restart SQL Server or update statistics, and the problem seems to go away - but only for a few days or weeks, and then it comes right back. You're familiar enough with execution plans to realize that you're getting different plans, but...why? And how do you fix it long term? In this session, you'll see live demos of the most common culprit: parameter sniffing. You'll learn how to recognize parameter sniffing when it strikes, understand what causes it, see how to fix it short term with the lowest impact possible, and learn 7 ways to fix it long term.

About Brent: Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit. He loves sharing knowledge at








Brent Ozar Unlimited

Back to Top