This isn't something you change with T-SQL, it would be done in the Configuration Manager in 2005 or the Server network Utility in 2000.

select a.value, b.value

from tableA a

inner join tableA b

on a.id = b.parentid

Queries against master have no impact on the server other than using resources to execute the query. There is not reason this should corrupt anything.

If you get this with a local backup, you have IO subsystem issues.

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...