Viewing 15 posts - 106 through 120 (of 230 total)
Just to add to Nigel's comments, once you do get the query straight to not get the dupes, a composite clustered index is not typically reccomended, but if you are...
November 30, 2003 at 6:38 pm
Great, thanks
Ray Higdon MCSE, MCDBA, CCNA
November 30, 2003 at 12:32 pm
I was at PASS and it was awesome, I didn't get a chance to talk with you guys but did admire the shirts other people received! I had already registered...
November 30, 2003 at 10:38 am
In your scenario you could restore the full backup, then the incremental, then the tran logs if the transaction happened after the incremental, if the tran happened before the incremental,...
November 30, 2003 at 10:33 am
I've seen something similar when working with BDE, setting the blob size to a higher number in the BDE worked for me.
HTH
Ray Higdon MCSE, MCDBA, CCNA
November 30, 2003 at 10:29 am
Also, keeping the commited transaction in the log allows you the chance to backup the log and have transactional recovery. Once you backup the log or truncate it, those commited...
November 30, 2003 at 10:23 am
Not sure what you mean, if it is in DW form, you could just DTS it back out, or you could use ROLAP as the storage form for your OLAP...
November 22, 2003 at 7:42 am
You can run traces with profiler for this
Ray Higdon MCSE, MCDBA, CCNA
November 18, 2003 at 9:13 pm
Distinct count is a problem when you have it in the same cubes as other measures, best way is to create one cube for the distinct count, another cube for...
November 18, 2003 at 9:09 pm
BOL has some good info, book by Reed Jacobson called Step-by-step analysis services is good
Ray Higdon MCSE, MCDBA, CCNA
November 18, 2003 at 9:08 pm
Just to add, you can run sp_spaceused with the updateusage command to get the same effect
sp_spaceused @updateusage = 'TRUE'
Ray Higdon MCSE, MCDBA, CCNA
November 18, 2003 at 9:01 pm
You can use xp_sendmail to send email notifications in a trigger, as far as notifying an application depends on what the app requires.
Ray Higdon MCSE, MCDBA, CCNA
October 21, 2003 at 7:08 am
5mb...JK, There is no definitive answer to this or the minimum size required for a transactional database without knowing what will be stored,type of database, number of transactions, number of...
October 21, 2003 at 7:05 am
quote:
A clustered index on an identity column can be a problem if page level locking is used. Every insert will likely...
October 16, 2003 at 6:05 am
When I've ran into stubborn logs, this script has helped
http://www.databasejournal.com/scripts/article.php/1446961
HTH
Ray Higdon MCSE, MCDBA, CCNA
October 16, 2003 at 5:56 am
Viewing 15 posts - 106 through 120 (of 230 total)