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:
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.