New T-SQL Features in SQL Server 2016

You can now set the MAXDOP option on each database differently:

ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 1;

Replacement for DBCC INPUTBUFFER:

sys.dm_exec_input_buffer()

Replacement for Trace Flag 1117:

AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES options on FileGroupLevel

Replacement for Trace Flag 1118:

MIXED_PAGE_ALLOCATION

on Database Level ^^.

 

 

See also: http://blogs.sqlsentry.com/team-posts/latest-builds-sql-server-2016/

Leave a Reply

Your email address will not be published. Required fields are marked *