Join for free and connect with our local tech scene
Stay on top of the latest companies and upcoming events with our weekly newsletter, and be counted among the people building the future of your local tech community.
Beyond SELECT: Query Tuning for Data Manipulation
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.
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.
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).
• 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