Brent Ozar Presents Tuning Indexes to Avoid Blocking

Event Information

Share this event

Date and Time

Location

Location

WeKnowIT

440 Knox Abbott Drive

Suite 425

Cayce, SC 29033

View Map

Event description
Brent Ozar Presents Tuning Indexes to Avoid Blocking

About this Event

You're getting complaints and alerts about blocking and deadlocking. You've tried slathering NOLOCK all over the queries, and that's not enough. You might be able to change the code, but you'd really rather make a few indexing tweaks to make it all disappear. Can it work?

Bio: Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at http://BrentOzar.com.

Brent Ozar will start with the StackOverflow.dbo.Users table from his free online How to Think Like the Engine class, and run updates against this table to see why SELECT queries won't make progress. He'll show you how to fix it by aiming for his 5/5 rule.

Date and Time

Location

WeKnowIT

440 Knox Abbott Drive

Suite 425

Cayce, SC 29033

View Map

Save This Event

Event Saved