Search for a command to run...
Series
In this Series we will be looking at various problems and inconsistency caused due to multiple concurrent executions in SQL Server. We will also be discussing the ways to handle and solve the problems
Overview of Transaction and Concurrency Any Relational Database System has a concept called Transaction. The transaction can be defined as a set of logical operations that has to be performed in a single session instance. In simpler terms, a Transact...
A transaction is a group of T-SQL statements performing single or multiple operations on objects as a single unit. If any of the statements in the transaction fails, then the whole operation reverts due to transaction rollback. This assures that thos...