Summary
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").
More information
This update is included in Cumulative Update 2 for SQL Server 2016 Service Pack 1.
Each new build for SQL Server 2016 contains all the hotfixes and all the security fixes that were included with the previous build. We recommend that you install the latest build for SQL Server 2016.
References
Learn about the terminology Microsoft uses to describe software updates.
