I’m very happy to announce today that I will be back with my already famous SQL Server Performance Tuning Workshop in London this year! This 5-day long workshop is scheduled from June 1 to June 5 in Central London. Besides London I also run this workshop in Utrecht/Netherlands from April 13 – 17. There are …
SQL Server Performance Tuning Workshop in London, June 2015 + read more
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
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.
