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.
Telling Which Platform You Run On With SERVERPROPERTY EngineEdition
Read EngineEdition with edition and version properties, select platform-aware diagnostics, and avoid treating an engine family as a license.
Network Packet Size: When a Bigger Packet Helps Large Results
Test network packet size on a specific SQL Server connection, verify the negotiated value, and compare large-result performance carefully.
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.
Getting Started With R Services and Forecasting
R Services and forecasting meet when a data scientist’s R script has to run next to the data. This guest post by Eduardo Castro shows how to enable external scripts, install packages and run a forecast with sp_execute_external_script.
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.