BIMLbimlscriptDatabaseDevelopmentPerformanceScriptSQL 2012SQL 2014SQL 2016T-SQL

Enlarge AdventureWorksDW2012

sql-bannerJust recently I had to have a big datawarehouse solution to test some performance optimization using BIML.

I could use the AdventureWorks2012 database, but I needed the clean datawarehouse tables in order to have minimum data maintennance when testing the BIML scripts.

I could not find it, and figures out it was faster to make my own.

So heavily inspired by this post from Jonathan Kehayias (blog), I’ve made a script that can be used to enlarge the dbo.FactInternetSales table.

The script creates a new table called dbo.FactInternetSalesEnlarged and copies data from dbo.FactInternetSales into it with a randomizer. Exploding the data to a 100 times bigger table – est. 6 mio rows.

Get the script here:

EnlargeAdventureWorksDW2012

Happy coding 🙂

 

Leave a Reply

Your email address will not be published. Required fields are marked *