Midlands PASS

Welcome to the Midlands PASS

Next Meeting

Tuesday,

November

12

Brent Ozar Presents Tuning Indexes to Avoid Blocking

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.

Featured Presentation:

Brent Ozar Presents Tuning Indexes to Avoid Blocking

Brent Ozar, Microsoft Certified Master of SQL Server Brent Ozar Unlimited

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.

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

PASSChapterLogo.jpg

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids