Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why?
Register for our Geek Sync, Faster Transactions: Query Tuning for Data Manipulation, on Wednesday February 26 at 11 AM CT, with host Jeff Iannucci.
In this demo-filled Geek Sync webinar we will discuss 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 what techniques you can use to improve performance.
Speaker: 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 is a 2020 IDERA ACE.
You can view the session slides here and the replay is available in the IDERA Resource Center.
Powered by IDERA