Thanks for the update. If you get the DNS specifics, I'm sure this would be a good thread to update for others.

I thought this was interesting, and I've dealt with this in a few places. If you don't have to work with the financial system, you might not encounter this. It...

BTW, I bought a 2500sq ft house in Va (SE) for $140k in late 1997, sold for $150k in 1999. A little over a year later, bought essentially the same...

Spending $160k a year.

Make sure you have indexed the columns.

Is there a reason that you cannot check for an AND with both columns? As in Jeffrey's first example.

First google result for me: http://www.mssqltips.com/tip.asp?tip=1046

You enter the mirror server in the connection string.

Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;

Depending on how the CAST works on the data, you could end up with different values. What you need to do is cast specifically to a size and ensure that...

You can setup a linked server between them, or you can use the OPENQUERY command from one server to get data from the other.

Without more details it's hard to know, but typically a report that presents row data as a column is a crosstab report. You can search on that, or look up...

Are those flat files there for DR? Or were they loads of some sort?

You can't make them pay. Businesses don't do what's right, or what's most efficient. Often it's the most cost effective, and if that means less service or some loss of...

Sorry I haven't been back in here. I wasn't thinking that fillfactor would speed things up, but it might reduce the need to defragment.

I would also follow Piotr's advice of...

I seconded the advice, which was sound. My guess is we have someone misleading people about their knowledge, or stuck in a bad situation. It's a coin flip, and I...

A few links for you:

http://www.sqlservercentral.com/articles/1535/

http://www.sqlservercentral.com/articles/701/

http://www.sqlservercentral.com/articles/1353/

http://www.sqlservercentral.com/articles/62480/

I second Alvin's notes. You aren't qualified to do this, and if you lead on the company to think you are, both of you will regret...