SQL Server Quickie #36 – Cross Joins
Today I have uploaded SQL Server Quickie #36 to YouTube. This time I’m talking about Cross Joins in SQL Server. Thanks for your time, -Klaus
In-Memory OLTP and too less Memory
I have already blogged a few times about In-Memory OLTP and why I don’t yet recommend this technology currently to my customers. Today I want to talk a little bit more about the memory requirements behind In-Memory OLTP, and what happens if you have too little memory. It’s all about Memory! We all know that …
Crash Recovery & Recovery Models
A few weeks ago I released a SQL Server Quickie about Crash Recovery in SQL Server. There was one interesting comment about whether the Recovery Model of the database influences Crash Recovery and if you would lose transactions in the Recovery Model Simple. Therefore I want to take this point today and talk in more …
SQLpassion Workshops in Fall 2016
Time goes by, and today I’m very proud to announce all upcoming SQLpassion workshops for fall 2016: SQL Server Query Tuning Workshop November 7 – November 11 in Utrecht/Netherlands SQL Server Performance Tuning Workshop October 31 – November 4 in Copenhagen/Denmark November 21 – November 25 in Zurich/Switzerland November 28 – December 2 in Frankfurt/Germany …
Why do we need Intent Locks in SQL Server?
I blogged 2 years ago about why we need UPDATE locks in SQL Server. Today I want to continue this discussion by talking about Intent Locks in SQL Server, and why they are needed. The Lock Hierarchy in SQL Server When I talked about Lock Escalations in SQL Server, I started by briefly mentioning that …
