There's a slight difference between a paid trip into outer space...

Hugo Kornelis (2/4/2011)

I chose the correct answer because I considered the scenario of a database with a long-running transaction. When the oldest active VLF is necessary for tha ttransaction, no...

What do you mean by SQL Client 2000? If you mean Enterprise Manager that ships with SQL 2000, you can't use it to manage a SQL 2005 database.

Especially considering the "reprint" of Gail's excellent articles on the subject recently...

ReadyBoost is more of a replacement for insufficient RAM than anything...if you have plenty of RAM you won't see much benefit from using it. Oh, and you need a decent...

Have you tried reading the rest of the comments? It's...

To add to what Steve is saying about the probabilities--let's say one of the disks in that eight-disk array has already failed. With RAID 0+1 we lose all our data...

James Lean (1/26/2011)

And obviously on the flip-side, you could lose one disk from each stripe set in RAID 0+1 and lose all the data; or you could lose both disks...

"So that's what you wanted? Whoops!"

The explanation given for that doesn't ring true. What usually happens to cause that comment, in my experience, is that the specifications were extremely clear...they...

Oddly, I was about to mention that 12 hours to backup 38Gb sounds like USB 1.1 transfer rates, but I see you've found that out for yourself. 🙂

Tom.Thomson (1/24/2011)

Another potential issue is physical deterioration of the media. This does happen as discs get older. In the old days drive hardware (or in even older days,...

If you ran a logfile shrink in between each table reindex I wouldn't expect it to help at all, because all the information you've just put in the log file...

It isn't an option because you're running the database...

Tb level databases? I have enough problems with the few Gb databases that are all I ever need to deal with! 🙂

I got it right apart from the last option--the reference I was looking at didn't mention anything about TOP performance being affected by this. Not greatly saddened because I don't...