love the work you're doing here, but can we expect SQL2014 based samples any time soon or should we be just using the olders ones? E.g. SQL2012.
Id #21112 | Release:
| Updated: Jun 30, 2014 at 5:25 AM by CraigHumphrey | Created: Jun 30, 2014 at 5:25 AM by CraigHumphrey
The table DimProduct of the Adventure Works 2012 DW seems to be incomplete, as for example SubCategorykey is null and son on.
Id #20725 | Release:
| Updated: Feb 12, 2014 at 10:35 PM by darktagnan | Created: Feb 12, 2014 at 10:35 PM by darktagnan
There seams to be an issue with the AdventureWorksDW2012 Data file download. When I try to run this SQL statement:
CREATE DATABASE AdventureWorksDW2012 ON (FILENAME = 'E:\MSSQL11.SQL02\MSSQL\DATA\...
Id #19063 | Release:
| Updated: Feb 22, 2013 at 1:37 AM by dscheierman | Created: Dec 14, 2012 at 4:05 PM by dscheierman
I'm trying to install Adventureworks sample dB and i get an error.
I successfully downloaded the mdf file however when attach, add and click OK from SSMS I get the error:
Msg 5172, Level 16, Stat...
Id #18174 | Release:
| Updated: Feb 22, 2013 at 1:37 AM by pleasehelpme99 | Created: Jun 2, 2012 at 12:07 AM by pleasehelpme99
The AdventureWorks 2008R2 SR1 Installer has been removed or is no longer available here:
This appears to be the only place to download ...
Id #18022 | Release:
| Updated: Feb 22, 2013 at 1:37 AM by mtnbikePeru | Created: May 9, 2012 at 9:31 PM by mtnbikePeru
New to datawarehousing...and want to know how the Adventurework and AdventureworkDW has been developed..
how the OLTP data has been extracted to AdventureworksDW..datawarehouse system and need some...
Id #17881 | Release:
| Updated: Feb 22, 2013 at 1:37 AM by bsurendiran | Created: Apr 19, 2012 at 11:57 AM by bsurendiran
We have a .net app and of course it requires reporting future. Anyone uses this app is going to login and base on database roles (stored in an Oracle DB) they are able to see their screens on this...
Id #14903 | Release:
| Updated: Feb 22, 2013 at 1:37 AM by rv7a99cv | Created: Dec 17, 2010 at 12:09 AM by rv7a99cv
Hi, I am working on a Report Services project and I just need to be able to check if a directory (based on user and it’s LDAP group) exist or not. I have used T-SQL, used VB.NET code inside report...
Id #14377 | Release:
| Updated: Feb 22, 2013 at 1:37 AM by rv7a99cv | Created: Oct 5, 2010 at 4:23 PM by rv7a99cv
If this is not the right place to ask questions, can you please point me to it? The pages will list comments, but don't show a way to add them.
Where can I find the Northwind database for S...
Id #13429 | Release:
| Updated: Feb 22, 2013 at 1:37 AM by PatrickLambin | Created: Jun 2, 2010 at 11:30 PM by DavidThi808
There is a gap in dates between 2008 and 2010 in the AdventureWorksDW2008R2 DimDate table. PerformancePoint Server (and Services) requires continguous dates for the Time Intelligence feature to fun...
Id #13383 | Release:
| Updated: Feb 22, 2013 at 1:37 AM by petermyers | Created: May 28, 2010 at 9:33 PM by petermyers