Dear Jeff,

Thank you for kind help!

I quite agree with you!

my said procedure, I just want to verify  how the transaction(rollback) works on the said scripts, actually, when the 1st block...

Dear All,

for the said question1 to question4, I encoded some source code to test and I already understand, for the case 1 to case 4, there is only one spid ...

Thank you Mike and Chris. but I have one question about sql server process (SPID) .

there are two stored procedures.one is SP1 the other is sp2. sp1 and sp2 has...

thank you Grant Fritchey!

I just want to know if there is another way to do it. I know extended event can do it. thanks!

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.