I am running SQL Server 2012 Enterprise Edition. I have downloaded the AdventureWorks 2012 OLTP data files (both .mdf and .ldf). I saved them to the AW folder that I created in My Documents where I...

I've been looking at Microsoft's Adventure Works 2012 database. I'd be very interested if there's any information explaining why the tables were created as they are. Some sort of schema overview I ...

I want to count the cities by gender, like this; City GenderFCount GenderMCount Redmond 10 20 Here is my query gets city and gender in AdventureWorks database select Gender,City from HumanReso...

Am having trouble in understanding how FILTER function works in MDX. Here is my query which gets all the non-empty Internet Order Count values for all Sales Territory Countries across all the Cale...

I'd like to install AdventureWorks2008 (I just install SQL Server 2008 R2 Express). Each time I download the recommended version from CodePlex, all I get is a AdventureWorks2008.mdf file. Not only...

I downloaded and installed AdventureWorks db for sql server 2008. Are there any exercises or tutorials for it? I'd like to to practice SQL select statements