What tools or techniques would you suggest for generating large amounts of SQL test data?
I would like to highlight some of my SQL queries and learn about bad query plans and bottlenecks. I am planning to populate some tables with random test data .
Are there tools or set of scripts available for this purpose, preferably for SQL Server?
Thank!
UPDATE: Sorry, didn't know these two questions already exist:
source to share
This website will generate custom data data for you.
From this site:
Ever needed custom formatted samples / test data for example bad? Well, that's the idea behind the Data Generator. It is a free, open source script written in JavaScript, PHP and MySQL that allows you to quickly create large amounts of custom data in various formats for use in test software, populating databases, and girl counting.
This site offers an online demo where you can tinker around to get a feel for what the script is doing, what the features it offers and how it works. Then, once you feel your appetite, there is a free, fully functional, licensed version of GNU available for download.
source to share