Viewing 15 posts - 316 through 330 (of 901 total)
Bhuvnesh (2/18/2013)
Jason-299789 (2/18/2013)
you could use the WITH RECOMPILE option on SP's as its a data warehouse so theres not a major impact with this.
HOw this wouldnt hurt the performance....
February 18, 2013 at 1:06 am
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...
February 18, 2013 at 12:54 am
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...
February 18, 2013 at 12:04 am
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...
February 15, 2013 at 4:05 am
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...
February 15, 2013 at 3:24 am
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.
February 15, 2013 at 2:02 am
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.
February 15, 2013 at 1:03 am
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...
February 15, 2013 at 12:18 am
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
February 14, 2013 at 4:17 am
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...
February 14, 2013 at 12:12 am
To my knowledge you cant even if the PK is nonclustered.
February 13, 2013 at 9:22 am
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...
February 12, 2013 at 7:50 am
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...
February 12, 2013 at 4:48 am
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...
February 12, 2013 at 2:59 am
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.
February 12, 2013 at 2:48 am
Viewing 15 posts - 316 through 330 (of 901 total)