Viewing 15 posts - 316 through 330 (of 902 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....
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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...
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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...
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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...
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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...
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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...
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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...
_________________________________________________________________________
SSC Guide to Posting and Best Practices
February 14, 2013 at 12:12 am
To my knowledge you cant even if the PK is nonclustered.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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...
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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...
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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...
_________________________________________________________________________
SSC Guide to Posting and Best Practices
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.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
February 12, 2013 at 2:48 am
Viewing 15 posts - 316 through 330 (of 902 total)