In today’s blog posting I want to talk about 2 kinds of deadlocks that can occur when you run transactions in the Transaction Isolation Level Repeatable Read. When you set your transaction to use the isolation level Repeatable Read, SQL Server holds acquired Shared Locks for reading data until the end of the transaction (COMMIT …
Possible Deadlocks in the Isolation Level Repeatable Read + read more
Today I’m very happy and proud to announce the SQLpassion workshop schedule around Europe for 2015. The following locations are currently scheduled and planned: SQL Server Query Tuning Workshop in Vienna/Austria (March 16 – 19, 2015) SQL Server Performance Tuning Workshop in Utrecht/Netherlands (April 13 – 17, 2015) SQL Server Query Tuning Workshop in Zurich/Switzerland …
Announcing the SQLpassion workshop schedule for 2015 + read more
Today I have uploaded the 20th SQL Server Quickie to YouTube. This time I’m talking about CXPACKET Waits in SQL Server. Thanks for watching! -Klaus
In today’s blog posting I want to demonstrate how missing indexes on tables can cause deadlocks in SQL Server. For the preparation of the test scenario the following code creates 2 tables and populates both tables with 4 records. — Create a table without any indexes CREATE TABLE Table1 ( Column1 INT, Column2 INT ) …
Deadlocks caused by Missing Indexes in SQL Server + read more
In my last week’s blog posting I talked about how the use of temp tables can cause recompilations in SQL Server. As mentioned at the very end of the blog posting, I want to concentrate today a little bit more on Table Variables, which can avoid the expensive overhead of recompilations. Let’s have a more …
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
