Notes From A SQL 2017 Azure Install – Trace Flags
Like most Database Administrators, I have a standard set of Trace Flags that I implement on my SQL Servers. These are my tried and true trusty companions, used to help …
Generating A Database Snapshot For DBCC CHECKDB
Many people don’t realize that DBCC CHECKDB actually uses an internal database snapshot of the database to run the consistency checks on. (See the “Internal Database Snapshot” section of the …
Discover Which Deprecated Features Are Being Used
With each new release of SQL Server comes a list of new features, along with a list of features that have been deprecated. These deprecated features are not immediately disabled …
You Can Now Specify MAXDOP For DBCC CheckDB!
I just stumbled on this today. According to the DBCC CheckDB documentation, as of SQL Server 2014 Service Pack 2 you can now specify MAXDOP when running DBCC CheckDB! The documentation states: …
What Features Are Disabled Between Compatibility Levels In SQL Server?
Have you ever wondered what features may or may not be available when your database is running in a different compatibility level than your SQL Server version? I recently came …