This update makes the following changes in Microsoft SQL Server 2016:
- Changes the data type of the "instant_file_initialization_enabled" column in the sys.dm_server_services dynamic management view from nvarchar(256) to nvarchar(2). Additionally, it becomes not nullable.
- Changes the "sql_memory_model" column in the sys.dm_os_sys_info dynamic management view to be not nullable.
- Changes the value "Conventional" of the "sql_memory_model_desc" column in the sys.dm_os_sys_info dynamic management view to all upper-cased ("CONVENTIONAL").
Article ID: 4013125 - Last Review: 21 Mar 2017 - Revision: 14