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 to Boolean. 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: Mar 20, 2017 - Revision: 13