If you set the instance to use a TCP port, it will use that one (if available when the instance starts). I believe the dynamic assignment is done after the...

IF you manually increase tempdb to 200GB or so, does it work?

There isn't a good way to do this, but there are ways. You can shell out and use SQLCMD or bcp to pull data out. You can setup an SSIS...

If you have Enterprise edition, you can do some filegroup restores and bring on sections of your database, but you'd want to have designed this ahead of time.

I make time to read all the time. Often 10 minutes here and there throughout the day, while eating lunch, waiting for kids, etc. I probably get in 30-60 minutes...

I don't know, but typically advisors don't require a license.

It depends. Do you need every clustered instance to work the same if there is a failover? If so, then 64/3 makes sense. If you assume failovers are rare and...

I think you made a mistake there of not restoring when you had one node.

I haven't done this, but I'd be nervous about this. Not sure if there is...

I have some friends that do this, HOWEVER, they have each VM on separate physical nodes (blades in this case). You must have separate physical hardware, and separate IO paths...

Red Herring from me, though I only did a quick check to be sure it was a fake from my side. If someone created it, I didn't see it in...

There is a password policy in SQL Server 2005, and if the host OS supports it, SQL Server can respect that. I thought the SA account was immune, but...

Agree with David on this one. Nothing should blow up

Be curious to know why stored procs are a nightmare for insert/updates.

sprocs encapsulate functionality, make it easier to maintain, IMHO for everyone. Cut and paste on the client means the...

Be sure you check the logic as a SELECT first.

http://www.rentacoder.com as well