Today I want to talk more about Plan Caching and its side-effects in SQL Server. As you might know, every logical query submitted to SQL Server is compiled into a physical execution plan. That execution plan is afterwards cached in the so-called Plan Cache for further reuse. Let’s talk in the first step about adhoc SQL statements …
I have previously very often talked on my weblog about Bookmark Lookups in SQL Server, and how bad they can be regarding the various problems they introduce. In today’s blog posting I want to talk a little bit more about the performance aspect of Bookmark Lookups, and how they can slow down your whole SQL …
The Performance Penalty of Bookmark Lookups in SQL Server + read more
Today I have published my 2nd Web Cast on YouTube. In this Web Cast I have talked today about CXPACKET Waits in SQL Server. Make sure to signup for my next Web Cast on March 28 where I will talk about Extended Eents in SQL Server. Thanks for your time, -Klaus
Today I’ve published my SQLpassion Online Trainings for March 2017. On March 27 I’m running again a one-day long webinar about how to implement SQL Server Index Tuning Strategies On March 28 I’m doing again a free webcast from 11:00 – 12:00 (GMT + 1), where I will give you an introduction to Extended Events …
In todays blog posting I want to talk about how to handle Deadlocks in SQL Server. A deadlock occurs when 2 queries are waiting for each other, and no query can continue its work anymore. In the first step I want to give you an overview how SQL Server handles deadlocks. And finally I will show …
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.
