Faster Transactions: Query Tuning for Data Manipulation

Abstract:

Your server has dozens of CPUs, terabytes of RAM, and uses solid-state drives…and yet your UPDATE statement still takes hours. Why? In this demo-filled session, we examine common pitfalls for any SQL Server professional who manipulates large sets of data with INSERT, UPDATE, and DELETE statements, and explore techniques you can use to improve performance.

Speakers:

  • Jeff Iannucci

    1 Recording
    Jeff Iannucci is a Senior Consultant with Straight Path Solutions. With over 20 years of experience with SQL Server development and administration, he enjoys sharing what he's learned by speaking, blogging, and creating video content. He is a speaker at PASS Data Community Summit 2022, a content author for Pluralsight, and author of the upcoming book "Learn SQL in a Month of Lunches".

Recorded At:

Recorded on:

Feb 25, 2023

More Info:

https://sqlsaturday.com/2023-02-25-sqlsaturday1043/#schedule

Tags: