Updated the StackOverflow SQL Server Database Torrent to 2016-03

Original news: https://www.brentozar.com/archive/2016/04/updated-stackoverflow-sql-server-database-torrent-2016-03/

The StackOverflow XML Data Dump was recently updated with 2016-03 data and Brent Ozar updated his torrent of the SQL Server database version of the Stack Overflow data dump.

Fun facts about the database and its real-world-ness:

  • 95GB in size
  • 29,499,660 posts spanning 2008-07-31 to 2016-03-06
  • 5,277,831 users spanning ages from -972 to 96 (just like real world data, you can't trust it)
  • 46,306,538 comments (227 of which have the F-bomb)
  • Every table has a clustered key on an Id identity field, and has relationships to other tables' Ids (again, much more real-world-ish)
  • Lots of lumpy data distribution and sizes, making it fun for parameter sniffing demos
  • Case-sensitive collation (because if you’re going to share scripts online, you want to get used to testing them on case sensitive servers – this stuff exists out in the real world)
  • 1,305% cooler than AdventureWorks

Torrent of the SQL Server database version of the Stack Overflow data dump

Next Post Previous Post