Forgot my SA password, and I don't have sysadmin rights...So, say you're at a new client site, or maybe even an old client site, and someone brings to your attention that they have this old SQL...
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...