Query hinting in action.
When I try to find a bug in the dynamic SQL that generates dynamic SQL…
When I virtualize the old Sybase server
When I fix the problem within 30 seconds of getting the outage page.
How I feel after I troubleshoot an AlwaysOn Availability Group problem.
When my junior DBA asked what I did with our training budget
When I get to the part of the query that says WITH (HOLDLOCK), which causes it to go serializable
The first time I try to use Extended Events to catch a bad query in action.
When each new round of developers builds a proof of concept, and then quits the company before their stuff becomes production/legacy
When I try to understand Paul White’s latest blog post.
When I use a WAITFOR in a query so that it sleeps before running again
When I try to tune SQLCLR.
When the junior sysadmin puts all my databases on RAID 5 magnetic hard drives
When I watch brentozar tune queries.
How DBCC SHRINKFILE really works.