SQL Server Quickie #19 – The Halloween Problem
Today I have uploaded the 19th SQL Server Quickie to YouTube. This time I’m talking about the Halloween Problem in SQL Server. Thanks for watching! -Klaus
SQLServer
Parameter Sniffing, Part 2
In last week’s blog posting I introduced the basic concept and the problems behind Parameter Sniffing in SQL Server. As you have seen, it can lead to serious performance problems when a cached plan is blindly reused by SQL Server. Today I want to show you how you can deal with this problem, and how …
Parameter Sniffing, Part 1
In today’s blog posting I want to talk about one major performance problem that I see very often during SQL Server consulting engagements – the so-called Parameter Sniffing problem. This problem occurs when you work with parameterized SQL statements like stored procedures in combination with the plan caching mechanism of SQL Server. In the first …
My SQLBits Attendee feedback
A few weeks ago, I got my SQLBits attendee feedback, and therefore I want to talk about it today. As you might know I have presented 2 sessions in Telford: one about Latches, Spinlocks, and Lock Free Data Structures, and another one about the Dangerous Beauty of Bookmark Lookups. Latches, Spinlocks, and Lock Free Data …
Lock-Free Data Structures
A few weeks ago, I blogged about Latches and Spinlocks in SQL Server. Both synchronization primitives are used to protect shared data structures within SQL Server, like pages in the Buffer Pool (through Latches) or locks in the Lock Manager’s hashtable (through a Spinlock). A completely new synchronization paradigm that you will see more and …
