top of page
Topic
Recent Posts
Archive
Tags
Extended Event
SQL Extended events are used to generate event data, process that data, correlate it with system events if necessary, and send it to a...
Application lock
Application locks open up the whole world of SQL Server locks for custom uses within applications. Instead of using data as a locked...
Locking behavior
There are various resources for learning SQL Lock behavior, including https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2...
About XACT_ABORT()
What makes this difficult is that most errors do not stop processing , so when you have a group of modification statements running in a...
savepoints within transactions
A savepoint is a named location from which a transaction can restart if part of it is conditionally canceled. That means you can rollback...
Identify missing indexes
When the query optimizer compiles a T-SQL statement, it also tracks up to 500 indexes that could have been used if they had existed. The...
WITH NOCHECK
If you create a table like this: CREATE TABLE Examples.BadData ( PositiveValue int NOT NULL ); INSERT INTO Examples.BadData(PositiveVa...
Changes to the transient data
You are designing a data warehouse that will be clustered across four servers. Several of the tables in the data warehouse contain...
ABOUT "ROWLOCK"
ROWLOCK specifies that row locks are taken when page or table locks are ordinarily taken. When specified in transactions operating at the...
Enable row versioning for lock
You have a database named HR1 that includes a table named Employee. You have several read-only, historical reports that contain regularly...
bottom of page