SQL Server User Group Monthly Meeting

Title: Breaking Bad Habits: Solutions for Common Query Antipatterns

Abstract: You wrote a query that returns the correct results, but even with supporting indexes it's just way too slow. What’s going on? In this session we will focus on T-SQL query anti-patterns - those commonly used techniques that are unintentionally counter-productive. Through an interactive story of user requests we will note how these anti-patterns occur, discuss what makes them troublesome, and show alternative methods to improve your query performance.

Speaker: Jeff Iannucci

Speaker Bio: Jeff Iannucci is a Senior DBA for DriveTime in Tempe, AZ. He has over 20 years of SQL Server experience as both Database Administrator and Developer in diverse environments such as health care, finance, retail sales, and government. He writes about solving problems for database professionals on both twitter (@DesertDBA) and his blog (desertdba.com).

Agenda:

• 5:30-5:45pm: Sign-in & network
• 5:45-6:00pm: Announcements & Intro
• 6:00-7:00pm: Presentation
• 7:00-7:15pm: Q&A, wrap-up, clean-up

Location:

DriveTime
1720 West Rio Salado Pkwy
Tempe, AZ 85281

Please enter the North-East side of the building into the auditorium area as the main entrance (center on the North side) will be closed.

Sponsor: AZSSUG