SQL Server 2016 discontinued trace flag 1117 and 1118 for TempDB. Use the options in ALTER DATABASE instead, as I found on a client server.
SQL SERVER 2016 – DBCC Command Enhancement with MAXDOP
SQL Server 2016 lets you set MAXDOP on DBCC checks like CHECKDB. Here is how this DBCC Command enhancement works and how to use it.
SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance
How I helped a customer get better performance by setting the AUTO_CLOSE Database Option to OFF, and why this setting hurts busy databases.
Interview Question of the Week #061 – How to Retrieve SQL Server Configuration?
A common interview question: how do you retrieve SQL Server configuration? Right-click and Properties is not enough. Here is the better answer.
SQL SERVER – A Brief Note on SET TEXTSIZE
Is there any difference between the LEFT function and SET TEXTSIZE? A quick script shows how each one trims a long VARCHAR(MAX) value in the results.
SQL SERVER – Check Advanced Server Configuration
How do you Check Advanced Server Configuration values? Turn on show advanced options with sp_configure, run RECONFIGURE, then run sp_configure to list them.
SQL SERVER – FIX : Error: Msg 15123, Level 16 – The configuration option ‘advance option’ does not exist, or it may be an advanced option.
Msg 15123 says the configuration option does not exist or may be an advanced option. Turn on show advanced options with sp_configure first, then set it.