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
SQLServer
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 …
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 …
Lock Escalations – do they always happen?
I blogged some time ago about the basics of Lock Escalations in SQL Server, and how even the plan shape can influence Lock Escalations. Today I want to talk further about Lock Escalations: do they always happen? When does a Lock Escalation happen? In general a Lock Escalation happens in SQL Server if you have …
