SQL Server Quickie #20 – CXPACKET Waits
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
Deadlocks caused by Missing Indexes in SQL Server
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
Recompilations, Part 2
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 …
Recompilations, Part 1
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 …
How to feel the SQLpassion in your veins
The last month was really time consuming for me: I was running my brand-new SQL Server Query Tuning Workshop 3 times across Europe: Zurich/Switzerland, London/United Kingdom, and finally in Vienna/Austria. The workshop runs for 4 days, and I teach almost everything you need to know to write better and faster performing SQL queries for SQL …
