The mirror's always in "recovering" state, waiting for more transactions. If you turn it off, it might be expecting that you'll turn it on, and I wouldn't want the SQL...

Do you mean indexed views?

More details would help. It would be good to know as well what the input rate is, perhaps using a trace to determine where things are...

I'd think merge as well. Is the same data potentially being updated as well in both locations? If so, you need something like merge, or write your own merge, which...

fundamentally sound meaning a strong design and good foundation or storing audio data?

I'd think that meta data is the key with audio data to be sure it can be found,...

That's an interesting one, and you might need to contact MS on this. Express should do multiple instances without an issue, but I can see that the languages could be...

Not sure how I can do that. It's hard to vet someone on a group like we have.

Please send possible issues to me and I'll look into them.

I think personal recommendations are great, and it's easier to get them from your employees than from previous employers at least that's been my experience.

I guess my comment about them...

Wayne,

I can't believe your licenses are bound to the hardware. I think that's a DOJ violation. Dell might not want you to move, but I've moved Windows licenses from Dell...

We've got a group. I typically process the requests on Fridays, so you might wait a week to get added.

I was thinking of the Florida "chad" debacle that we went through.

What's "best qualified?"

Not sure what that is for a DBA, much less President.

Never a guarantee, not never works out. 😉

I agree with you, but I've seen people give out references, including former bosses that were co-workers. If you call XYZ corp and...

The changes are written to the log, so they're on disk, just not in the data file.

If you request a page that's been changed in memory, but not on disk,...

Call PSS. You may have hardware issues, but you don't want to lose data. I'd suspend database activity and call PSS for now to diagnose the issues.

And how we counted votes :w00t:

Sorry was responding to mailsar, who mentioned deleting data and joining back to tables.

I think you can trap the DDL for truncate, but not sure about the data. Perhaps a...