Paresh: Your cut and paste was in reference to High Avail style mirroring

Perry: You were talking about automatic failover.

Don't do either one with a normal internet type connection!

My...

Which...

What really matters here is: What is the purpose? How busy is the primary database? How much bandwidth are you willing to pay for? My following...

I've often wondered (but not hard enough to actually lift my fingers and go reading on my own) if doing a backup, drop DB, restore sequence gave you a completely...

anam (11/17/2008)

Now i am looking after any technique which will help me in changing the recovery state of the database till i get extra disk on my server for...

To move a database from one server to another, and setup for mirroring, I have done this successfully:

On Server A (was main, will be the mirror):

Run full backup

Run tail of...

Absolute? Make backups. Verify Backups. Keep Backups safe.

Oh yeah, test Backups.

Seldom is the answer "never do it this way". It often "depends".

We host a "stock exchange" server for our customers. They trade a lot of documents and data...

I don't think separate or same channels on the same card will make much difference, it's getting them on separate drive groups that matters. The more separate drive spindles...

My guess is both were excellent choices, but the...

I'll be the one to ask the idiot question:

When is it advantageous to use a table variable? Since I started in Version 7, when they didn't exist, I just...

Why wouldn't you simply detach the database, then attach it back with the single file option? Sorry, I'm in a hurry this morning, but I'm almost certain I've moved...

Pet Peeve: I hate it when someone writes an article (even someone whom I greatly respect) and uses an acronym that (in my world at least) is not exactly...

Wait, I found it on urban dictionary, and now I hate it more. I mean, who wants to be "dorky"?

Something that has adequate or better performance. Combination of "Performance"...

What the hell does "performant" mean? To the best of my searching, it's not a word and has no meaning. I've seen it in a couple of other...