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
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 …
SQL Server Quickie #18 – Bookmark Lookups
Today I have uploaded the 18th SQL Server Quickie to YouTube. This time I’m talking about Bookmark Lookups in SQL Server. Thanks for watching! -Klaus
