When you cannot figure out why the query isn’t working, and then you realize you put it in Notepad.
Accidental F5 during self code review.
Code was solid in the first place.
When we find a table in an old production database (built circa SQL 2000) that has over 90 varchar(8000) columns and nearly all of the values are null (15 columns actually contain data).
When I see a wait type of CHECK_TABLES_THREAD_BARRIER on SQL 2016 server, do some web searches, and the the description of that type on the Microsoft Docs website says “TBD”
Brent Ozar Unlimited's highly specialized experts focus on your goals, diagnose your toughest IT pains, and prescribe remedies.
Be the first to know about new deals! Sign up today and start receiving offers from your favorite stores into your mailbox.
Go to Brentozar.com and paste the code on checkout page.