Little Maz DBA

MS SQL 2016 just got a whole lot cooler....

MS SQL 2016 SP1 has arrived! Hurrah I hear you say...

https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/

Those nice people at Microsoft have given the standard edition a whole load of extra benefits which previously only on the enterprise edition of MS SQL server.

The following table compares the list of features which were only available in Enterprise edition which are now enabled in Standard, Web, Express, and LocalDB editions with SQL Server 2016 SP1

Think my fav new addition is the Database clone command! Troubleshoot our production databases by cloning the schema and metadata, statistics without the data.

 –– Default CLONE WITH SCHEMA, STATISTICS and QUERYSTORE metadata.
DBCC CLONEDATABASE  (source_database_name, target_database_name) 

–– SCHEMA AND QUERY STORE ONLY CLONE
DBCC CLONEDATABASE  (source_database_name, target_database_name) WITH NO_STATISTICS                                 


–– SCHEMA AND STATISTICS ONLY CLONE
DBCC CLONEDATABASE  (source_database_name, target_database_name) WITH NO_QUERYSTORE 


 –– SCHEMA ONLY CLONE
DBCC CLONEDATABASE  (source_database_name, target_database_name) WITH NO_STATISTICS,NO_QUERYSTORE   

Download SP1

https://www.microsoft.com/en-us/download/details.aspx?id=54276


Catch ya soon!
Little Maz