Bhuvnesh (2/18/2013)

HOw this wouldnt hurt the performance....

I'm working on a project that has a very similar problem, and we found on investigation that a lot of the issues were around suboptimal code, database structure, lack of...

It sounds like your source has duplicated rows, in this case its usually because the process that built the source dataset is incorrect, or that there is a data anomaly...

It depends, what is the ETL process, is it a snapshot Fact (as is) or incremental with Insert new update existing, or Contra correction logic as the decision will have...

Fair Point Gail,

In then end it comes down to evaluating the requirement and looking at the reason for putting the BIT column on that particular index, then evaluating...

Gail,

I would say it depends on various factors, but as a general rule I would look at having it in the Include column list initially, and then evaluate.

Can you post the Actual Execution plan as well as the DDL for the Tables, and indexes.

These will enable people to offer practical solutions.

There is nothing to stop you adding a BIT data type to an Index, HOWEVER, it will have very low cardinality, as there are basically 3 states, True, False, and...

Also worth a read is this http://www.red-gate.com/community/books/accidental-dba or you can buy it from amazon, just follow the amazon link.

Edit : Also on that link that Anthony sent

If you want the Top 10 Items per month then a Ranking function (RANK(), ROW_NUMBER()) is going to be the best way to move.

However without sample DDL and...

To my knowledge you cant even if the PK is nonclustered.

You need a union all as there is a chance that the amount in the bottom and top are the same, also you dont need to do the sum in...

Why would you want to cross join this data, it makes no sense to have Customer Y's service records against customer X, besides theres an impicit link between service data...

To check the easiest way is to goto Start->All Programs->SQL Server <version>->configuration tools and select the SQL Server configuration Manager, under that you should see the SQL Server Analysis...

Have you checked that SSAS is installed and the service running.

If it is then its possible that you forgot to add yourself as an administrator during the installation.