I've seen chiropractors for pinched nerves. Gave me short term relief, not much long term help. Acupuncture worked better for me.

Try what you like, find something that works, keep your...

Date formats are stored in a binary format, your client interprets that.

Look at CONVERT for the codes and formatting needed to get the dates into particular varchar formats.

I'm confused. Are you getting one warm standby for multiple primaries?

I like VMWare, but keep in mind you'd take a decent sized IO hit here as well as resource loss....

I think you need two nodes to add those things. The other node could be a virtual server, which is what I'd recommend. Or rather, two virtual servers that are...

We do announce things periodically and this is more of a question that rewards those long time members rather than is a learning experience.

Not sure when we'll go to 2008....

Tend to agree with you above. Don't install something you don't need.

I think this is a RAC competitor, just like Scalable Shared Databases or replicating to slaves.

Log shipping existed in many installations before Microsoft built a support solution, this might end...

SP2 had some issues, notably Maintenance plans. I'd go to Cumulative update 2 or 3 at least.

This sounds like homework.

Please post these as separate items, and not as a poll. Use the Add Topic button.

Also, do some research. Explain what you're trying to do and show...

Best of luck with the new job.

Sometimes you ride a bad wave of luck and have trouble with jobs. It's happened to me before. Do something good for someone else...

And if you shrank the database, you might have caused a lot of fragmentation. Be sure you reindex.

Can't go below original size, AFAIK.

Build a new db, script things out, xfer data.

I think we have to agree to disagree.

you're citing specific instances to show a general problem, but that's not the case. 4 digit years might cause problems, might not, might...

Ron, send the home address to me via PM and I'll look into it. Having some strange issues with the email process at times, usually Blacklist related, but it could...

Index things? Rewrite the query? Both are possible ways to speed things up, but without more details, can't really give more advice.

What's the query and the table DDL (and indexes)?