The Art of War with Bad Code
Let’s face it, many of us are at war with poorly written or poorly tuned queries and processes. There is usually just one of you who has been tasked with managing one or more SQL Server instances while there are hundreds or even thousands of users of which a certain percentage will inevitably write poor code. So you must battle it out to identify the culprits before they wreak too much havoc on your systems. We will see several fairly straightforward techniques to positively identify the culprits and allow you to prioritize your efforts in tuning them to give you the biggest ROI for your time. TSQL and Extended Events code examples will be provided that you can use immediately in your environment to become more productive.