Bigger sample databases

I like Northwind and Pubs. They're cute.
But, if you're trying to train on issues surrounding performance testing,
having a much larger database would be advantageous.
Is there any resources to get larger sample databases from?
Thanks!
http://www.microsoft.com/downloads/d...8-2BFB66F0ABDC
For performance testing there is no substitute for using data that matches
or approximates your own production data. Test data generation ought to be
part of your project plan for new projects.
David Portas
SQL Server MVP
|||David,
Thanks, this is just what I was looking for! Since I'm still working on
an MCDBA cert, I don't really have any "production data" I can use yet. But,
this Adventure Works DB looks like what I needed.
I guess why I need it is that as I train, I want to compare various
options. For instance, which is faster, using subqueries or joins between
tables in T-SQL statements? When you only have 16 records in a table, it's a
little difficult to do "real world analysis" to answer performance questions
like that.
Thanks again!
"David Portas" wrote:

> http://www.microsoft.com/downloads/d...8-2BFB66F0ABDC
> For performance testing there is no substitute for using data that matches
> or approximates your own production data. Test data generation ought to be
> part of your project plan for new projects.
> --
> David Portas
> SQL Server MVP
> --
>
>
|||Joel wrote:
> I like Northwind and Pubs. They're cute.
> But, if you're trying to train on issues surrounding performance
> testing, having a much larger database would be advantageous.
> Is there any resources to get larger sample databases from?
> Thanks!
BigNW Script attached. Scott's web site is down. See file for comments
related to new database size and file / backup locations.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||I get to this newsgroup by browsing to:
http://msdn.microsoft.com/newsgroups...6-099a858cd211
...and find this post currently on page 4. I don't see anything for
attachments, just the text you wrote. How do I get the attachment?
Thanks!
"David Gugick" wrote:

> Joel wrote:
> BigNW Script attached. Scott's web site is down. See file for comments
> related to new database size and file / backup locations.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest
|||Joel wrote:
> I get to this newsgroup by browsing to:
> http://msdn.microsoft.com/newsgroups...6-099a858cd211
> ...and find this post currently on page 4. I don't see anything for
> attachments, just the text you wrote. How do I get the attachment?
>
Use a real news reader :-)
I see it from Outlook Express... The ng server name is
msnews.microsoft.com
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David,
Well, our company uses a standard desktop configuration, that doesn't
have Outlook or Outlook Express. There are no Exchange servers, as they use
Lotus Notes / Domino as their e-mail platform (Grrrr...). They seem to have
Internet news groups in Notes blocked as well (Grrrr....).
Is there any other way to get the script you're talking about? A web or
ftp site perhaps?
Thanks again...
"David Gugick" wrote:

> Joel wrote:
> Use a real news reader :-)
> I see it from Outlook Express... The ng server name is
> msnews.microsoft.com
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||Joel wrote:
> David,
> Well, our company uses a standard desktop configuration, that
> doesn't have Outlook or Outlook Express. There are no Exchange
> servers, as they use Lotus Notes / Domino as their e-mail platform
> (Grrrr...). They seem to have Internet news groups in Notes blocked
> as well (Grrrr....).
>
Send me an email. Remove the nospam from the email address.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Joel wrote:
> Is there any other way to get the script you're talking about?
> A web or ftp site perhaps?
Use Google Groups as a newsreader:
http://groups-beta.google.com/group/...be2b7e84054e82
Razvan
|||David,
Razvan Socol's post about using the Google news groups helped me. I
was able to get the script from your previous post.
Thanks for your help and your patience!
Joel
David Gugick wrote:
> Joel wrote:
> Send me an email. Remove the nospam from the email address.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com