Pittsburgh SQL Server Users Group

EventDisplay

Next Meeting: Tue, Aug 29 2017

Why do My Execution Plans Change? How do I Force the Best One?

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

.

When

iCal
UTC : Tue, Aug 29 2017 17:00 - 19:00
Event Time : Tue, Aug 29 2017 17:00 - 19:00 UTC
Your Local Time: Tue, Aug 29 2017 17:00 - 19:00

Where

Pittsburgh North Shore
Pittsburgh, Pennsylvania

Direction: None

Featured Presentation

Why do My Execution Plans Change? How do I Force the Best One?

Speaker: John Sterrett, Principal Consultant Procure SQL LLC

Summary: For this month's meeting, John will be presenting remotely. Join us at the Microsoft office for pizza, networking, and a John's presentation. Join John Sterrett, Principal Consultant at Procure SQL LLC to learn how execution plans get invalidated and why data skew could be the root cause to seeing different execution plans for the same query. We will look at the options for forcing a query to use a particular execution plan. Finally, you will learn how this complex problem can be identified and resolved simply using a new feature in SQL Server 2016 called Query Store.

About John: John Sterrett is an MCSE: Data Platform, Principal Consultant and the Founder of Procure SQL LLC. John has presented at many community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and the founder of the HADR Virtual Chapter.

Attachments

            

Thank you to our Sponsors!

PASSChapterLogo100.jpg

sql_micro_sm.gif

 

   

   

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids