Thursday, November 17, 2016

SQL Server 2016 Service Pack 1 (SP1) released

Microsoft has announced the availability of SQL Server 2016 Service Pack 1 (SP1). With SQL Server 2016 SP1 key improvements were made allowing a consistent programmability surface area for developers and organizations across SQL Server editions.

2. Now express edition has the lot of features where it was limited to enterprise before. Partitioning, Compression ad In Memory OLTP will be available now for Standard and Express as well.

2. DBCC CLONEDATABASE is added which was missing in SQL Server 2016 RTM and was with SQL Server 2014.

3. Tempdb supportability – A new Errorlog message indicating the number of tempdb files and notifying different size/autogrowth of tempdb data files at server startup.

4, DROP TABLE support for replication – DROP TABLE DDL support for replication to allow replication articles to be dropped.

For all the details, please refer to


  1. What an exciting set of features (on those editions)...Thank you very much Dinesh for the share..

  2. I am grateful for this blog to distribute knowledge about this significant topic. Here I found different segments and now I am going to use these new instructions with new enthusiasm.
    Cisco RV042