lopeb.blogg.se - Oracle sql database for mac stackoverflow

#Oracle sql database for mac stackoverflow how to#
#Oracle sql database for mac stackoverflow archive#
#Oracle sql database for mac stackoverflow full#
#Oracle sql database for mac stackoverflow code#
#Oracle sql database for mac stackoverflow download#

As you might not guess, the NVARCHAR(MAX) datatypes of the Comment and Text fields make those demos rather…challenging. As you can probably guess by the name, this would make for excellent partitioning and archival demos. Starting with this version & newer, the giant PostHistory table is included. 2018-06 – 38GB torrent ( magnet.) Expands to a ~304GB SQL Server 2008 database.2018-09 – 39GB torrent ( magnet.) Expands to a ~312GB SQL Server 2008 database.2018-12 – 41GB torrent ( magnet.) Expands to a ~323GB SQL Server 2008 database.2019-06 – 40GB torrent ( magnet.) Expands to a ~350GB SQL Server 2008 database.

This is the last export licensed with the cc-by-sa 3.0 license.

2019-09 – 43GB torrent ( magnet.) Expands to a ~352GB SQL Server 2008 database.

2019-12 – 52GB torrent ( magnet.) Expands to a ~361GB SQL Server 2008 database.

This is the last export that can be used with SQL Server 2014 & prior.

2020-06 – 46GB torrent ( magnet.) Expands to a ~381GB SQL Server 2008 database.

2021-02 – 54GB torrent ( magnet.) Expands to a ~401GB SQL Server 2016 database.

I also keep past versions online too in case you need to see a specific version for a demo.

For questions about the data, check the data-dump tag on.

#Oracle sql database for mac stackoverflow how to#

If you want to learn how to tune queries, is a fun source for queries written by other people.

This Meta.SE post explains the database schema.

To get started, here’s a few helpful links:

It only includes data, not data for other Stack sites.

The log file is small, and you should grow it out if you plan to build indexes or modify data.

#Oracle sql database for mac stackoverflow full#

No other indexes are included (nonclustered or full text).

All tables have a clustered index on Id, an identity field.

I want you to get started quickly while still keeping the database size small, so: That means you are free to share this database and adapt it for any purpose, even commercially, but you must attribute it to the original authors (not me):

#Oracle sql database for mac stackoverflow archive#

If your SSMS crashes or throws permissions errors, you likely tried extracting the archive directly into the database directory, and you’ve got permissions problems on the data/log files.Īs with the original data dump, this is provided under cc-by-sa 4.0 license. It doesn’t use any Enterprise Edition features like partitioning or compression, so you can attach it to Developer, Standard, or Enterprise Edition. It’s in Microsoft SQL Server 2016 format (2008 for the older torrents), so you can attach it to any 2016 or newer instance.

#Oracle sql database for mac stackoverflow download#

You’re going to screw up the database over time, and you’re going to want to start again – keep the original copy so you don’t have to download it again. Don’t extract the files directly into your SQL Server’s database directories – instead, extract them somewhere else first, and then move or copy them into the SQL Server’s database directories. (I use that for max compression to keep the downloads a little smaller.) The extract will have the database MDF, NDFs (additional data files), LDF, and a Readme.txt file. Because it’s so large, I only distribute it with BitTorrent, not direct download links.Īfter you download it, extract the.

For my training classes: specialized copy as of 2018/06: 47GB torrent ( magnet.) Expands to a ~180GB SQL Server 2016 database with queries and indexes specific to my training classes.

Because it’s so large, I only distribute it with BitTorrent, not direct download links.

Large: current 430GB database as of 2022-06: 54GB torrent ( magnet.) Expands to a ~430GB SQL Server 2016 database.

I use this in my Fundamentals classes because it’s big enough that slow queries will actually be kinda slow.

Expands to a ~50GB database called StackOverflow2013 with data from 2008 to 2013 data.

Medium: 50GB database as of 2013: 10GB direct download, or torrent or magnet.

#Oracle sql database for mac stackoverflow code#

If all you need is a quick, easy, friendly database for demos, and to follow along with code samples here on the blog, this is all you probably need. Expands to a ~10GB database called StackOverflow2010 with data from the years 2008 to 2010.

Small: 10GB database as of 2010: 1GB direct download, or torrent or magnet.

Plus, it’s open source and no charge for you – just choose your size: It’s easy to learn, has just a few easy-to-understand tables, and has real-world data distributions for numbers, dates, and strings. I use a Microsoft SQL Server version of the public Stack Overflow data export for my blog posts and training classes because it’s way more interesting than a lot of sample data sets out there.