Monday, April 09, 2012

This is Sparta...n SQL!: Scripting out statistics

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. 

This is Sparta...n SQL!: Scripting out statistics

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.

No comments: