Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2010-03-19 : 18:53:55
|
Good afternoon.I need your help with 2 questions tha ive got:1.in a delete command ie deleting a number of rows in table X i could see inmediatly that the command is working because for a while a use the select count (*).. and the numbers of records are decreasing, but with the insert command is not happening the same way, i mean, i only know the results until the command insert has finished. is there any other t-sql command to see if the insert command is adding rows and not to wait until the inser command has finished.2. if id process A is being blocked by id process B, in someway process B decrease performance because of process B (Blocking Process) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
DML Commands