Expanding the uses of DBCC CLONEDATABASE

Geschrieben von Database Magician am Dienstag, 27. September 2016

'Service Pack 2 for SQL Server 2014 was released last month (read the release notes here) and includes a new DBCC statement: DBCC CLONEDATABASE. I was pretty excited to see this command introduced, as it provides a very easy way to copy a database schema, including statistics, which can be used for testing query performance without requiring all the space needed for the data in the database. I finally made some time to test out DBCC CLONEDATABASE and understand the limitations, and I have to say it was rather fun.'...

https://sqlperformance.com/2016/08/sql-statistics/expanding-dbcc-clonedatabase