Free Sample Database for Download: SQLIndexWorkbook

A new sample database is born!

A new sample database is born!

A little while back, I wrote about free sample datasets on the internet.

One of my favorite datasets is the list of names given to babies in the United States each year since 1880. The data is simple enough to be small, and just weird enough to be fascinating. The data’s published in 134 .csv files (and counting– it’s one per year), which takes a little fiddling to get into a database.

So I did the work for you. I imported the files into SQL Server, did a little normalization, and set up a compressed backup file for download.

Download the Database

Download the free SQLIndexWorkbook™ database here.

The backup file is small by design – this first published version is under 11MB.

The restored database size is 1.5GB (1 GB datafile, 512MB log file).

Restore it And Start Querying

After you download sqlindexworkbook.zip, take it for a test restore and run some basic queries.

Stay Tuned

I love this sample dataset for the portability of the backup file, and I have lots of cool scripts in the works that will be coming to you soon on this blog. We’ll expand the data, manipulate it, and work through all sorts of indexing problems.

And I promise to update the sample database with 2015 baby names as soon as they’re published. 🙂

Viva la index!

, ,

3 Responses to Free Sample Database for Download: SQLIndexWorkbook

  1. Thiago January 7, 2016 at 3:59 am #

    Thank you for that! It’s always cool do querys in other relations once in awhile…

  2. Lee M January 8, 2016 at 8:50 pm #

    Kendra, Thanks for doing the work to create this database. I’m already doing some experimenting. I look forward to your posts about indexes based on this database.

Leave a Reply