An interesting technique for building a VSDB (Very Small Database) with a very large query plan profile. If you have a huge database and don’t want to do performance testing of procedures in production, mirroring statistics could be a way to simulate this activity using tiny or even empty tables.
I recently read an excellent post by Kevin Kline regarding scripting out histograms from one database and applying them to another. What would have made it better is if there was a way to automate it. And so I pulled out powershell and got to work.
There should really be a tool that clones the schema of a database and the statistics of a database while clearing out the data or subsets of the data.