SQL Server 2016 Released.Posted: June 9, 2016
SQL Server 2016 RTM was released on June 1st, 2016.
Today, I setup a VM with a standard version running on Windows 2012 R2.
A few numbers I came across:
The version number is 13.01601.5 (select @@version) and the comparability level is 130.
The internal version is 852. (SELECT name,version,* FROM sys.sysdatabases)
The SQL Server 2014 SP1 has a version number 12.0.4449.0, the comparability level 120 and internal version 782.
When I create the first object in a new database on the new instance, I found the first object’s object_id is 565577053 and the second one is 581577110 (select 565577053+ 16000057 ).
The magic prime number: 16000057.
In previous two versions (2012 and 2014) , the first object_id in a new database was 245575913.
It seems this starting number was pushed up 20 times to start. (select (565577053-245575913) /16000057).
SQL Server 2016 (SP1) – 13.0.4001.0 :
The first object’s id in SQL Server 2016 SP1 is : 565577053