Adventureworks database for SQL Server 2016

Question

Adventureworks database for SQL Server 2016

curious_sqldba

SSC-Dedicated

Points: 36502
More actions
July 2, 2015 at 8:03 am

#298312

On Microsoft's website https://msdn.microsoft.com/en-us/library/hh231699.aspx they point to AW of SQL 2014 to be used, wondering if there is any 2016 AW database

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Unlikely there will be an official demo DB until after launch. Features are still changing, we're still in preview. It's no impossible that queries written now won't work come release.

Use the 2014 one and try out the new features by yourself.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 2

I agree with Gail.

When using AdventureWorks 2014 with SQL 2016, I would check the Compatibility Level and set it to SQL 2016, if not already set that way.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Grant Fritchey SSC Guru Points: 399059 More actions · Answer 3

The AdventureWorks databases are almost never released before the product. I know this because every time I'm working on a book prior to the release I have to use the older database. It means either telling people to use that older database with the book, or, going through a period of retest right before the book comes out. Both are less than enjoyable.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Almighty SSCrazy Points: 2016 More actions · Answer 4

Ohh Yes .. even on MS virtual LAB they Show DAtabase Adventure works 2016 but the compatibility level is of 120

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Echoing what has been said. Just use the 2014 version of AW. The database likely won't change much for 2016. It hasn't really changed in that last few releases.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Gareth Swan Old Hand Points: 391 More actions · Answer 6

Here you go, guys - The NEW database for use with SQL Server 2016. AdventureWorks is dead. Long live Wide World Importers !!! https://github.com/Microsoft/sql-server-samples/blob/master/samples/databases/wide-world-importers/documentation/root.md It even comes with an SSIS package which should be good to use for demos.

MadAdmin SSChampion Points: 11261 More actions · Answer 7

Gareth Swan (6/2/2016)
Here you go, guys - The NEW database for use with SQL Server 2016. AdventureWorks is dead. Long live Wide World Importers !!! https://github.com/Microsoft/sql-server-samples/blob/master/samples/databases/wide-world-importers/documentation/root.md It even comes with an SSIS package which should be good to use for demos.

That is odd.

I could have sworn I installed AdventureWorks2016CTP3 and AdventureWorksDW2016CTP3 which I downloaded from here

<https://www.microsoft.com/en-us/download/details.aspx?id=49502> AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3, which had new features available.

Or is this spam for Github?

Catch-all queries done right [/url]
Gail Shaw's Performance Blog[/url]

Gareth Swan Old Hand Points: 391 More actions · Answer 8

Yes, I have seen and used the AdventureWorks2016CTP databases, as well.

I don't know if there will be an updated version for the RTM or not.

We happened to find the new WWI databases and thought we could use those.

Adventureworks database for SQL Server 2016

Cookies on SQLServerCentral