 |
Advanced Lock Monitoring
|
| Total Hit (2968) |
In order to assist continuous and effective monitoring of lock status, SQL Server offers the system stored procedure SP_LOCK, which can provide several useful pieces of information on how locks are set and removed.
However, using this information - such as process ID, database ID, and object ID -
....Read More |
Rating
 |
|
|
|
|
|
SQL Server Lock ( NOLOCK and ROWLOCK )
|
| Total Hit (13222) |
Relational databases, like Microsoft's SQL Server, use locks to prevent multiple users from making conflicting modifications to a set of data. When a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data and relinquishes the
....Read More |
Rating
 |
|
|
|
How to implement simple transaction in SQL Server
|
| Total Hit (2219) |
Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks in the group successfully complete. If any of the tasks fails, the transaction fails. Therefore, a transaction has only two results: success or failure. Incomplete
....Read More |
| Rating
|
|
|
|
How to implement nested transactions
|
| Total Hit (4395) |
SQL Server allows you to nest transactions. Basically, this feature means that a new transaction can start even though the previous one is not complete. Transact-SQL allows you to nest transaction operations by issuing nested BEGIN TRAN commands. The @@TRANCOUNT automatic variable can be queried to
....Read More |
| Rating
|
|
|
|
How to do error handling in transaction.
|
| Total Hit (2283) |
The examples presented here are specific to stored procedures as they are the desired method of interacting with a database. When an error is encountered within a stored procedure, the best you can do is halt the sequential processing of the code and either branch to another code segment in the proc
....Read More |
| Rating
|
|
|
|
SAVE TRAN and Save Points.
|
| Total Hit (2612) |
Savepoints offer a mechanism to roll back portions of transactions. A user can set a savepoint, or marker, within a transaction. The savepoint defines a location to which a transaction can return if part of the transaction is conditionally canceled. SQL Server allows you to use savepoints via the SA
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
Locking in SQL Server 7.0
|
| Total Hit (1881) |
In this article, I want to tell you about general details of SQL Server 7.0 locking, about Transaction Isolation Levels, what kind of Transaction Isolation Level exists, and how you can set the appropriate Transaction Isolation Level, about Lock types and Locking optimizer hints, about Lock Escalati
....Read More |
| Rating
|
|
|
|
|
|
|
|