I keep seeing the words "bookmark lookup" float by.

I'm thinking that's what's causing your first query to be slow. Since the name isn't included in the non-clustered index, a...

glad that worked out for you. Thanks for the feedback!

Was replication set on that DB? If so and it hasn't replicated, it will not "release" that space. It releases transactions that are committed AND replicated (if replication...

I could give you the price we (when I was there) got as a not-for-profit, academic healthcare org as part of a multi-year Software Assurance contract, but that would just...

If you're not going to get any cooperation from your IT shop, then I'm not quite sure what to tell you. You may be better off leaving them alone....

Remember though - a deletion being successful does NOT mean it found something and deleted...

I agree with Jsheldon. It's going to be painful, but you need to at least start transferring the tables, and progressively re-write the queries to leverage SQL's power.

There's a...

I'm thinking you mean Active/Passive (since ony one of the node has access to SQL server at any given time), or do you have multiple instances?

Did you follow this procedure?

http://technet.microsoft.com/en-us/library/ms179530.aspx

Othwerwise...

Look at using Select ... INTO

Example:

Select *

INTO MyNewTable

from MyOldTable

Uses whatever it derives from the query to make a table.

You could turn it into a datetime value, and then format the output correctly. That would handle your display/conversion issue.

It would look something like:

select convert(char,dateadd(second,15794,0),108)

Just be sure that you only include "mother teresa-like" organizations, or unimpeachable ones. Anything controversial at all should NOT be included. A resume writer advised I drop things...

that's...

That's what is called "expanding a hierarchy". Microsoft has posted an example on how to do just that. It's here:

http://msdn2.microsoft.com/en-us/library/aa172799(SQL.80).aspx

The order of the join isn't going to fix "missing" data. If tables 2 and 3 don't have data matching column a1 in Table1, then there will be rows...

No problem - we all have things to learn. I learn stuff every day, and I've been playing with various database formats for nearly 20 years now.

Whether importing using...