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
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