February '12 Baton Rouge SQL Server User Group Meeting

Topic:  Execution Plans: Beyond the Basics 

Date: Wednesday, February 8, 2012

Location: LSU Campus, Turead Hall Room 103 - http://g.co/maps/xb5pf

Sponsored By: TBA

Agenda:

5:45 - 6:15 pm: Networking and Refreshments

6:15 - 6:55 pm: Lightning Round Topics

6:55 - 8:00 pm: Main Topic

8:00 - until: Open Forum for questions and Raffle

Afterwards: An open invitation to join us at Walk-Ons

Lightning Round Speaker: Patrick LeBlanc, Microsoft

Topic: New Features of SQL 2012

Lightning Round Speaker: Matt Maddox, Lamar Advertising

Topic: TBA

Main Topic: Execution Plans: Beyond the Basics 

Main Topic Speaker: Thomas Leblanc, Turner Industries

Summary: This will session will be a deeper look into execution plans for query tuning. The Nested, Merge and Hash Join loops will be discussed. A look at TempDB usage when memory grants are not enough for the plan. How do you use MAXDOP and Cost Threshold to understand parallel plans? We will examine Sort, Compute scalar and more iterators for performance tuning. Missing indexes in query plans will be used to help performance.

Bio:  Thomas is a Senior DBA at Turner Industries, LLC in Baton Rouge, LA. He has worked in the IT field for 22 years and has experience w/ COBOL dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and .Net(C#). Designing and developing normalized database has become his passion and is continuing with Dimensional Models. Full-time DBA work started about 10 years ago at the Tembec paper mill and continued with IEM and Amedisys. He has been blessed with speaking at SQLRally and SQLPASS in 2011 and at SQLSaturday’s in Colorado Springs, New York, Houston, Dallas, Pensacola and Baton Rouge(2). Thomas’ free time is spent helping other & improving his relationship with family & God. He can be contacted on twitter @TheSmilingDBA and blogs regularly at TheSmilingDBA.Blogspot.com