The fastest way to process large amounts of data in SQL Server is using set-based operations. That is if you can stand the blocking. This session walks through different ways to think about applications when transaction blocking becomes your biggest problem. It covers specific T-SQL suggestions to minimize the rows locked, application architectures to maximize concurrency and reporting solutions to reduce impact on the production database. And always lots of demos and spirited discussion.
Presented By: Bill Graziano
Bill Graziano is a SQL Server consultant specializing in high-throughput transaction environments using SQL Server. He spends his days counting the milliseconds behind credit card swipes. Bill is the former President of PASS, a global non-profit professional association for users of Microsoft's data platform. PASS has over 100,000 members and 200 chapters around the world. Bill also runs a web site for SQL Server developers and administrators at SQLTeam.com.