Page Splits, should I worry?I wish page splits were delicious. What are page splits? Page splits occur when a data page gets filled with data and a new page is...
Capture Query Information with Extended EventsMany of us have not made the effort to switch from profiler to Extended events. It's 2018, if you haven't found a few hours to learn...
Reading the Deadlock GraphIt's important to be able to analyze the deadlock graph once it's been detected. I'm going to give a brief run down on what I look at....