What is your clustered index on? If this is a composite clustered index you will always get unpredictable logical IO (page reads).

If you main goal is to reduce IO on...

Great!

Ray Higdon MCSE, MCDBA, CCNA

I have seen this before, if I recall right this is a bug. Try to change your tran log from running 06:00-22:00 to running 06:00-22:15 (or anything other than the...

First thing is to go to http://www.microsoft.com/mcp and get the details on the exams there. For SQL, the best resource to start with is BOL (books-online) the latest can be...

To add to Andy's post, When it comes to things like this I would recommend lots of playing (or educated guesses, whichever you want to call it)

99% of the time...

Frank is right, a classic example was a man in California had a license plate that said "none". When he received a traffic ticket he was held liable for thousands...

If it is a big database, DTS'ing out all the tables makes me cringe. I just purchased an 80gb external USB hard drive from Circuit City for $99. Don't rule...

update table set column = null

where ...

Are you having problems with setting the column to null? Does it allow nulls or is it an identity column?

HTH

Ray Higdon MCSE, MCDBA, CCNA

Ah, I did not know that about text columns, shows how often I work with them, thanks for the enlightenment Brian.

Ray Higdon MCSE, MCDBA, CCNA

You don't have to use an instead of trigger to track all changes, you can right the audit part in a standard trigger, How are you auditing and I'd reccomend...

This might help

http://www.support.microsoft.com/?id=317375

Ray Higdon MCSE, MCDBA, CCNA

You could place a backup file on a disk (if it will fit) or on a hard drive and restore it as the destination server. If you will need to...

You can use backup/restore or sp_attach_db, look in BOL for syntax

HTH

Ray Higdon MCSE, MCDBA, CCNA

Can you explain why you would not allow the update so that you code everthing in the trigger? If you are doing this for auditing reasons, you can allow the...

If he was able to change to bulk-logged he is on SQL 2000. Davinash, change to full mode then try to run

backup log dbname with truncate_only

Then run your shrinkfile command,...