transactions

Last Post 02 Oct 2006 04:48 AM by ufohj. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
krotach
New Member
New Member

--
22 Sep 2006 02:57 AM
HI,

I am a DBA/Developer and and am looking for further documentation concerning trasactions and overhead. For example. I have a developer that regularly puts transactions (Begin trans, rollback trans, etc) in each proc. He also puts them around implicit trans like this:

Begin trans

Update statement

Check for error
Commit or rollback.

I can't help but think this will put extra overhead on processing. I can't find details about what exactly happens. Any documentation would help. I am trying to convince him to take the transaction statements out.

Thanks.
krotach
New Member
New Member

--
22 Sep 2006 04:40 AM
I think you are missing the point. SQL Server does implicit transactions. so, in my example, I am talking about 1 update statement that is already doing an implicit transaction. Question is - will wrapping an implicit transaction in a begin trans statement cause additional overhead?
ufohj
New Member
New Member

--
02 Oct 2006 04:48 AM
Yeah.

rm is almost always right.
You are not authorized to post a reply.

Acceptable Use Policy