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...

Great, thanks

Ray Higdon MCSE, MCDBA, CCNA

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...

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,...

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

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...

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...

You can run traces with profiler for this

Ray Higdon MCSE, MCDBA, CCNA

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...

BOL has some good info, book by Reed Jacobson called Step-by-step analysis services is good

Ray Higdon MCSE, MCDBA, CCNA

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

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

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...

quote:

---

A clustered index on an identity column can be a problem if page level locking is used. Every insert will likely...

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