Category Archives: Concurrency

ROLLBACK damn you!

A good question was asked on #SQLHELP the other day regarding the use of XACT_ABORT ON - “If you don’t have a BEGIN TRAN COMMIT TRAN in a stored procedure, will SET XACT_ABORT ON do anything?”. My immediate reply to this … Continue reading

Posted in Concurrency, sql, SQLServerPedia Syndication | Leave a comment

Passionate about SQLpassion

If you are new or experienced to the world of SQL Server you will be aware that one of SQL Server’s greatest strengths is the copious amounts of literature and videos available to you covering subjects ranging from the basic … Continue reading

Posted in sql, performance, parallelism, SQLServerPedia Syndication, personaldevelopment, Concurrency, SQLPassion, Training | Leave a comment

Why don’t you go and LOCK OFF!

No this is not a Hekaton post :) -perhaps I should have saved this title for another rainy day. SQL Server concurrency is a particularly difficult subject to master and understanding the result of your actions can be confounded by … Continue reading

Posted in 24HOP, Concurrency, sql, SQLServerPedia Syndication, tsql | 2 Comments