Thinking Big (Adventure)

re: Thinking Big (Adventure)

SQLvariant — Mon, 17 Oct 2011 18:20:47 GMT

I noticed while running this script that the default grow for the AdventureWorks database is 16MB. You might want to advise people to bump that up by at least adding a zero to the end (160 MB).

Great script! Wish I had it 2 weeks ago! :-)

re: Thinking Big (Adventure)

Linchi Shea — Mon, 17 Oct 2011 21:01:59 GMT

The right thing for MS to do is to make AdventureWorks scalable with a scaling parameter and have the actual data generated per this scaling parameter. So if you want a 100GB AdventureWorks, adjust the parameter and generate a 100GB database. This is how most benchmarks scale their databases, and it has worked well.

re: Thinking Big (Adventure)

Adam Machanic — Tue, 18 Oct 2011 15:20:19 GMT

Linchi: I couldn't agree more. Connect item? :-)

re: Thinking Big (Adventure)

Julie Smith — Wed, 19 Oct 2011 01:30:43 GMT

Delicious way to trick out some larger data sets :)

re: Thinking Big (Adventure)

Jen McCown — Fri, 10 Feb 2012 06:55:53 GMT

Finally got around to downloading this...thanks Adam!

Big AdventureWorks2012

SSIS Junkie — Mon, 02 Apr 2012 22:19:36 GMT

Last week I launched AdventureWorks on Azure, an initiative to make SQL Azure accessible to anyone, in

Incremental loads in SSIS using the Lookup component and FNV1a hash in a synchronous script component | MarkGStacey

Sat, 11 May 2013 18:38:43 GMT

PingBack from http://markgstacey.net/2013/05/11/incremental-loads-in-ssis-using-the-lookup-component-and-fnv1a-hash-in-a-synchronous-script-component/

Incremental loads in SSIS using the Lookup component and FNV1a hash in a synchronous script component

Sat, 11 May 2013 18:40:11 GMT

PingBack from http://www.aphelionbi.com/2013/05/incremental-loads-in-ssis-using-the-lookup-component-and-fnv1a-hash-in-a-synchronous-script-component/