Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Smiling DBA

Thomas LeBlanc is a Business Intelligence Consultant/Data Warehouse Architect in Baton Rouge, Louisiana. He uses his 25+ years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL and end-to-end dimensional data marts using SSIS, SSAS, PPS, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is current chair of the Excel BI virtual chapter, past chair of the Data Architecture virtual chapter, and past virtual chapter mentor. He has helped the Baton Rouge SQL Server User Group with SQLSaturdays and speaks at local IT meetings.

Baton Rouge SQL Server User Group

I will be speaking at the February Baton Rouge SQL Server User Group meeting on Wednesday the 8th. The session will be an continuation of Execution Plan Basics that I shared last year and at 2 SQL Saturday events plus Houston Tech Fest in 2010. This one is called Execution Plan: Beyond The Basics. The topics include Digging deeper into Loops, Missing Indexes in Query Plans, WHERE clause and LEFT JOIN, TempDB usage, SQL Server 2012 improvements to Query Plan and Tools like SQLSentry’s Plan Explorer, Database Tuning Advisor and SP_WhoIsActive from Adam Mahanic.

I am hoping this session gets pick by some SQL Saturday events in the future, first at Houston with Nancy Hide Wilson and Jonathon Gardner. Still looking at Pensacola and waiting for John Sterret and gang in West Virginia to add one to the schedule. Really would like to do a half day execution plan session, that would be nice.

More Info:

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

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

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.

Comments

Leave a comment on the original post [thesmilingdba.blogspot.com, opens in a new window]

Loading comments...