dbcc showstatistics will give you the needed stats information but I do not believe you need  to manually run statistics

Mike

Is the old server getting offline?

How about creating a very large file to reduce autogrowth at least till the file gets there.The autogrowth process consumes useful resources when the extraction process could  be better served

Mike...

Thanks yelena

I do not have 2005 so your solution may not apply.

Mike

Thanks for your reply David.

Almost every query which joins a couple of tables has to be run twice or more to get timely results <2 minute from about 10 or...

Had this once and we were on the way to bouncing the server so never had to investigate since it went right after the bounce

Mike

update

the query has to be run a couple of times to be able to run properly.

Mike

go to database folder

all tasks generate sql for the indexes and manually drop them from the tables and you also get sql to drop objects

Mike

I think it is possible to group by more than one item

This reminds me of the NFL draft.Though those guys earn millions you want a guy you can keep,some one who has respect for themselves and for others some one who...

Create linked servers to all servers that count  and depending on the results of your query , update the fields on the server in question using the linked servers

Mike

Thank you that did it .The outer join came in very handy here .....

Mike

Thanks Johnrowan and jeyanthan for your answers.

Let me illustrate with values

t1                                                t2

1221  employee                     1221  employee

2111  employee                     2111 employee

2311  acquisition                    3111 employee

3211  employee                 

The purpose is to compare the two tables add absent...

Thanks for your response.It did not seem to do it though .

Let me restate the problem?

Purpose .Delete all rows found in t1 that are not in t2.These rows must have a...

There is a free   GUI tool out there called Sync SQL Logins which could be used to synchronize the logins

Mike