North Texas SQL Servers Users Group

Next Meeting: Thu, Apr 16 2020

16APRIL2020 NTSSUG MEETING - Breaking Bad Habits: Solutions for Common Query Antipatterns

RSVP URL: https://www.meetup.com/North-Texas-SQL-Server-User-Group/events/269925264/

MONTHLY NEWSLETTER

APRIL 2020 USER GROUP MEETING

 

 

 

NOTICE: LAST MONTH WE ASKED THAT ONLY LOCALS THAT WOULD NORMALLY ATTEND THE IN-PERSON MEETING TO ATTEND THE VIRTUAL MEETING. THAT MEETING WENT WELL AND WE DIDN'T COME ANYWHERE NEAR THE ATTENDEE LIMIT. BECAUSE OF THIS, THIS MONTH ANYONE IN OUR DISTRIBUTION LIST CAN ATTEND. WHAT'S GOING TO HAPPEN WITH THIS? WE DON'T KNOW...BUT I GUESS WE'LL FIND OUT. :)

 

Breaking Bad Habits: Solutions for Common Query Antipatterns

Abstract:  Your query returns the correct results, but even with supporting indexes it seems slow. Can it go any faster? In this session, we focus on T-SQL query antipatterns – commonly used techniques that are unintentionally counter-productive. Through an interactive story of user requests, we identify several antipatterns, examine what makes them troublesome, and show alternative methods to improve performance.

Speaker: Jeff Iannucci

Jeff Iannucci is a Senior Database Administrator for DriveTime in Tempe, AZ. He has over 20 years of SQL Server experience as both a DBA 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), and has been chosen as an IDERA ACE for 2020.

Meeting starts: 6:00 pm - go to your kitchen and get some dinner
Announcements & Ask the Experts: 6:30 pm to 7:00 pm
Presentation: 7:00 pm to 8:00 pm

When: Thursday, April 16, 2020

Address:
Microsoft Teams
Your House
Somewhere, Texas 750XX

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