Get Live Help
A Transact-SQL statement that terminates a SQL Server connection. Any outstanding transactions for the selected session are rolled back and all locks are released.
A Latch is like a mini-lock that is used internally by SQL Server to serialize access to certain resources. Latches do not participate in transactions and are typically held for very short durations.