Transactional Handling at Database Level | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transactional Handling at Database Level

Hi, Please provide me input when to use Transaction handline at Database Level or at Application Level. I am trying to find which is best in which all condition. If anyone you have any input please add your comments. Thansk and Regards
Ravi K
Hi Ravi, it depends on whether your application puts all statements for a single transaction into a single SQL call. This would be preferred for ease of maintenance and performance (esp if stored procs are used) Cheers
Twan
What kind of application is using this SQL server database?
Are you looking for performance based solution or a simple data consistency based approach? http://www.sqlteam.com/Item.asp?ItemID=11828
http://www.informit.com/articles/article.asp?p=26657
http://www.informit.com/articles/article.asp?p=26657&seqNum=5
http://www.4guysfromrolla.com/webtech/080305-1.shtml Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>