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...
New TempDB TraceFlagIn the past we're used to enabling Traceflags 1117 and 1118 in order to help with TempDB Contention. With the release of SQL 2016, these...