thank you for you kind help Grant Fritchey !

Sorry to bother you again ! could you please recommend  1 or 2  third party tool of data synchronization among databases ?...

Heh... guess I'm more ancient.  I've not found much that will actually beat BCP for...

Are you exporting the data to load into a different SQL Server instance?  If so, then you should "native" format on the output.  That will save a lot of...

Dear Erland Sommarskog, thanks for you kind help!

Thanks John ?Grant and Jeff for you kind help and benefit much from your suggestions! thanks!

Dear Brahmanand Shukla,

Got it , thank you for  your kind help!

Dear Brahmanand Shukla,  thank you for your kind help!

I meant I encoded 2 SQL statements to get the same result ,  if the numbers of physical reads plus  its logic...

Dear John, thanks for you good  suggestion.

but My question is that how to utilize the SQL Server log to analyse when there is a block in the database and the...

Thanks everyone for your good suggestion and  making me much clearer about execution plan. but I have one question about the physical reads and logic reads when executing two select...

Thanks everyone for you good suggestions, thanks...!

Actually,  when I executed these SQL statement I click the menu named Include Actual  Execution Plan. and don't know it still show estimated subtress cost etc.

Thanks Mike?Grant and Jeff for you kind  help !

I tested it with linked server and openquery and found it there was no any improvement in the performance.   but  I found...

do you mean    the reports--> standard reports  for each database , such as: all transactions , all blocking transactions ....?

If yes, do these reports just reflect the resources usage...

Anyway , Erland Sommarskog , thank you for your kind help !

if so, can we understand it as below ? thanks

1. first, create connection, then create session, finally create request?

2. one connection maybe includes more than one session and one session...