Backup, detach, restore.

If something blows up, just re-attach the DBs to the original server and repoint your apps.

I use this method whenever possible.

What is the size of all indexes together/size of the table?

sort_in_tempdb does in fact move the logging process for indexing to tempdb, but if it's on full recovery, then the...

In case that was a bit unclear, there's a few steps here...assuming you have logs taken at regular intervals (every 15 mins, every hour, etc):

1) Run the restore job to...

Don't forget to enable filestream for the job_responsibilities field if we're including DBAs.

I've used SP2010 and just set up the databases on our existing SQL 2k8 server we already had in-place...not a separate \sharepoint instance. I try to avoid letting SP (or...

Also keep in mind that every insert/update will take twice as long with an index like that (or longer, if any page splits/moves/etc occur).

I have a cluster running Win 2k3 x64 with the following SQL versions:

SQL 2000 Ent x86

SQL 2005 Ent x64

SQL 2008 Ent x64

All 3 have run on the same node during...

After I verify everything is working as it should (Backups being taken regularly, replication/log shipping/mirroring working OK, no outstanding issues/problems), I set up a centralized reporting database and feed data...

I never worry about a preferred node..Never really understood that anyway, since both nodes should be identical hardware/settings. It shouldn't matter which one it's on.

The first time you exec a query, it has to create an execution plan, pull the data, etc.

The second time, unless it has been flushed, it will already have the...

Unless it's causing an issue, I wouldn't worry about it. As far as I know it's just a label. I checked a few of my clusters and they all show...

Someone just touched on it...check your max degree of parallelism, and then check how many processes are waiting on CXPACKET. If you have a ton of cxpacket waits, lower your...

Looks like an SSMS/gui error. Try rebooting that computer, or connecting with SSMS from a different machine?

I'm pretty sure this happens because you created the cluster group first without any application in it, i.e. just an empty group, and then installed SQL onto it and pointed...

Even if you don't know the correct answer, describe your thought process to them. They're looking to see how well you handle things you might be unfamiliar with. If your...