I am working on a rather old .NET project and have introduced some new features (on top) that have generated the following side-effect: all generated SELECTs (or groups of) are wrapped in
BEGIN TRAN ... COMMIT statements.
This sounds silly, but getting rid of this requires a lot of changes and I cannot afford to do so. My assumption is this basically means a small overhead for each group of SELECTs (roundtrips between application and SQL Server for BEGIN TRAN and COMMIT).
I am wondering if there is more to this (extra locking?).
Question: Is there any side effect if select statements are wrapped in BEGIN TRAN ... COMMIT?