It can be quite a shock for developers to realize they can make radical changes to the data or schema, while testing, safe in the knowledge that it will take them only a few seconds to revert the database to its original state. Phil Factor demonstrates how it's done, using SQL Clone and PowerShell.
2019-04-11
rsNeatPublish: Toolset to automate deployment of all SSRS 2008R2/12/14/16 objects
2016-01-28
635 reads
As you pointed out the sysindexes script only works if the index statistics are kept up-to-date. I think your best bet would be to keep them up-to-date and use the script otherwise you would have to use a script to run SELECT COUNT(*) FROM etc which would definitely not be efficient.
2005-05-27
The users within a database have a SID column which matches to the SID value of the login.If you transfer your logins first then restoring your database will maintain your user to login relationship.The sp_change_users_login procedure is great when autofixing a username that is identical to the login name but otherwise you have to know […]
2004-09-13
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers