ranask_47 (9/16/2011)

---

is there any other way to write this query to improve efficiency? As the indexes are not the issue our database is very much evolved.

Here is the...

ranask_47 (9/16/2011)

---

@SSchasing

I have attached the updated document which describes what I am looking for.

This what I want to compile from the database:

The percentage of children 2 years of age who...

drew.allen (7/27/2011)

In its most basic form, think of it as AGGREGATE FACT BY DIMENSION. So the standard examples include TOTAL (aggregate) SALES (fact) by MONTH (Dimension). So you...

PaulB-TheOneAndOnly (7/26/2011)

---

Sqlraider (7/25/2011)

---

I am just getting into creating Dimension/Fact tables from our data warehouse using SQL Server 2008 R2, SSIS, & SSAS.

I currently have the following books:

The Data Warehouse ETL...

To late, I already sent this in!:-P

I just tell them I work in the Matrix.

I'm saving mine for retirement!

Check out this link:

http://msdn.microsoft.com/en-us/library/ms190698.aspx

Thanks for your reply.

I went looking to see if an AD account already existed, none found. I then located the server installation logs. When asked if the current user (network...

Steve Jones - SSC Editor (4/5/2011)

---

Thanks, I'm the last man standing, but certainly not the winner. Final standings:

Johan - 14

Allen - 10

Steve - 9

Bradley - 8

Sean - 7

sqlRaider - 6

Mark...

I'm game if it's not to late.

That is correct.

It was a port/firewall issue.

After more google research I was able to find the port causing the issue. The port was blocked by the firewall to remote connections. Once the...

I am new to this so bare with me.

I have version 10.50.1600.1 installed on my PC for SSMS & Analysis Services Client Tools.

I have tried to install drivers (but I...

I believe the OP is seeing the error in SQL Server Management Studio prior to execution.

I copied the script in and on the line:

SET PQI = 1

PQI is underlined in...