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 …
Today I’m very thrilled to come back to London to run from June 12 – 15 my SQL Server Performance Tuning Workshop. This will be a specialized version of the workshop, because it only lasts for 4 days (because of some timing constraints from the venue and my side). But a lot of knowledge transfer …
SQL Server Performance Tuning Workshop in London + read more
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.
