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...
DBCC CheckDB on a large DatabaseRunning CheckDB regularly is important for the integrity of your database. It's suggested that we run this as often as possible, so that...
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...