Need Sample Data

• Alan Burstein

  SSC Guru

  Points: 61141

  More actions

  March 31, 2015 at 12:04 pm

  #316765

  Hello everyone,

  I need a large sample dataset, e.g. a 1-3GB CSV. I usually use data.gov for this kind of thing but, for the project I am working on it the data needs to be completely non-controversial. E.g. I can't download Crime Statistics, Consumer complaints... It seems like all the huge CSV files on data.gov are things of this nature. For reasons I can't go into - I can't use adventureworksDW or anything from codeplex.

  I thought this would be simple but it's turning out to be a pain in the rear. I am having surprisingly bad luck when googling "Huge CSV sample data download" and stuff like that.

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  March 31, 2015 at 12:44 pm

  #1787838

  Maybe something here or here could help you.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• Alan Burstein

  SSC Guru

  Points: 61141

  More actions

  March 31, 2015 at 1:22 pm

  #1787845

  Thanks Luis. That stack overflow thread led me in the right direction.

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001