Arizona SQL Server Users Group

Next Meeting: Wed, Sep 12 2018

Beyond SELECT: Query Tuning for Data Manipulation

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Arizona-SQL-Server-User-Group/events/kvzxdmyxmbqb/

Title:

Beyond SELECT: Query Tuning for Data Manipulation

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. See pictures for more details.

Abstract:

Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session, we will discuss the common pitfalls for any SQL professional who is manipulating large sets of data with INSERT, UPDATE, and DELETE statements. Not only will you learn about potential issues involving data pages, locks, and the transaction log, but also how to spot problems before execution and what commands you can use to improve performance.

Speaker:

Jeff Iannucci

Speaker Bio:

Jeff Iannucci is Senior Database Administrator for Republic Services in Scottsdale, AZ. He has nearly 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-6:00pm: Sign-in & network
• 6:00-6:15pm: Announcements & Intro
• 6:15-7:15pm: Presentation
• 7:15-7:30pm: Q&A, wrap-up, clean-up

Sponsor: AZSSUG

When

iCal
UTC : Thu, Sep 13 2018 00:30 - 02:30
Event Time : Wed, Sep 12 2018 17:30 - 19:30 (UTC-07:00) Arizona
Your Local Time: Thu, Sep 13 2018 00:30 - 02:30

Where

1720 West Rio Salado Pkwy
Tempe, Arizona

Direction: None

Attachments

Meeting Archive

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