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 …
In this and next week I want to talk about a very important performance tuning topic in SQL Server: Recompilations. As you will see they can happen when you execute very simple stored procedures. Today I want to lay out the foundation of recompilations in SQL Server, why they have to happen, and next week I …
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.
