assuming you're in full recovery you can use one of the many log reading tools to recover the data. Redgate have one. likewise Lumigent. Be aware that very few of these...

you need to do a rebuild master to change server collation, any existing database you detatch first will then need to be recollated.

I don't have a free box to step...

in your documentation ?  I'm at a bit of a loss as I've never had problems isolating dts problems from the dts log - I first thought you needed logging...

once again the answer is "it just depends"  you certainly don't need the first non clustered index, and personally I'd probably drop invoicenumber into the third index and do away...

Partitioning of data is always a good idea, but, the performance gains are lost if access to the partitioned data is not controlled. I've used partitioned views with daily,weekly, monthly...

you'd just do so much better to not use EM for this and use QA or similar tool and code using a drop and create. Depending upon the dependencies an...

I'd guess that maybe the dependecies are not properly ordered or grouped. I'd take this to mean that sql was up before the drives, in cluster resource sql should depend...

yeah, don't use it, use the tuning advisor in 2005. If you don't have a 2005, download an eval.

I've looked at the tuning adisor a few times and had...

I collect database data size data daily and store in a table, once you have enough data you can analyse. I produce a report every day showing %age growth, from...

Well, I've only done this upgrade once on production - incorrect build and no-one noticed !!! - I didn't feel safe not re-applying the service packs ( 4 + 2187...

It's funny back in the days of small disks , 9gb for instance, there wasn't so much of an issue of raid 10 , one of the comments Jim Gray...

er yes!  If you'd read the kb you'd see that it said you should change back to your domain account. Yup a new account should be ok, make sure you...

Hmm .. I'd probably re-apply the last service pack to be sure especially on a production system.

generally I tend to call batch files - choose the Operating System Command ( CmdExe ) step type in the job.

I'm sure it's cluster aware and is applied to the virtual server - sorry don't do that many patches on clusters so tend to forget!