3/17/2024 0 Comments Adventureworks2012 lt script![]() It has a reasonable amount of data and its design is said to reflect current thoughts on best practices. ![]() But the “AdventureWorks series” is the new sample database, including an OLTP, data warehouse, and analysis databases, as well as case-senstive and case-insensitive collation versions. In SQL Server 2005, no sample databases are installed with the product by default, which is a good thing. Northwind was inherited from Microsoft Access, being the original Access sample database. I always point out that, of the 8 publishers in Pubs, only 3 have actually published books. The problem with Pubs was that it really didn’t have much data at all. Pubs was the sample database inherited from Sybase, although Sybase itself moved on to “Pubs2” last time I looked. Also known as AdventureWorksLT.īecause folks that teach SQL Server do have a bunch of canned queries for exposition and know exactly how those queries are supposed to behave, sample databases really never disappear. ![]() In the SP2 version, the samples included a new sample database, “AdventureWorks Light”. I always look through the SQL Server 2005 samples with each new incantation, and always seem to find things in there that are new and interesting. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |