@LitKnd LitKnd released this Feb 19, 2017 · 7 commits to master since this release

Assets 7

You've got a couple of different options for what to download. Both options contain national and state level name data from 1881 to 2015 from the Social Security Administration in the USA.

Option 1: Small BabbyNames

Download: BabbyNames.bak.zip

This is an 43MB compressed backup of a SQL Server database. It can be restored to a SQL Server instance which is 2016 or higher. This database is 2GB after being restored.

You can build this data instead of downloading by running CreateBabbyNames.sql.

Option 2: Large BabbyNames (BabbyNames_Partitioning)

Download: BabbyNames_Partitioning_1_of_4.bak.zip, BabbyNames_Partitioning_2_of_4.bak.zip, BabbyNames_Partitioning_3_of_4.bak.zip, BabbyNames_Partitioning_4_of_4.bak.zip

These four files can be restored to a SQL Server instance which is 2016 or higher. All 4 files are required for it to work. This database is 23GB after being restored.

This version of BabbyNames consists of the original data, plus two larger tables:

  • dbo.FirstNameByBirthDate_1966_2015 (not partitioned)
  • pt.FirstNameByBirthDate_1966_2015 (partitioned)

These tables contain "fake" row level data generated from the aggregate data from 1966-2015. They can be used for testing queries "before and after" partitioning.

You can build this data instead of downloading by running CreateBabbyNames.sql, then ExpandBabbyNames_Partitioning.sql.