SQL Server Quickie #33 – Deadlocks
Today I have uploaded SQL Server Quickie #33 to YouTube. This time I’m talking about Deadlocks in SQL Server. Thanks for your time, -Klaus
Lock Escalations and Execution Plan shapes
Lock Escalations are really, really bad, because you end up with an Exclusive or Shared Lock at the table level. And placing such restrictive locks at the table level reduces your concurrency and the throughput of your database. I don’t want to talk today about the basics of Lock Escalations. Today I want to concentrate …
Extent Management in SQL Server
I today’s blog posting I want to talk about Extent Management in SQL Server, because this is a very important topic, especially when it comes to TempDb. On a very high level an extent is just a group of 8 pages of 8kb. An extent is therefore always a chunk of 64kb. SQL Server internally …
The pain of Real-Time Data Analysis in SQL Server 2016
SQL Server 2016 provides you with a lot of new features and functionality around the ColumnStore index that was introduced back with SQL Server 2012. One of these new features is the ability to create a Filtered Non-Clustered ColumnStore Index on top of a regular Row-Store table. This might sound a bit surprising at first, …
The pain of Real-Time Data Analysis in SQL Server 2016 + read more
How to ruin your High Availability solution by using Virtualization
It happens very often these days: people contact me because they want some help from me in designing their High Availability solution for SQL Server. There are already a lot of people who are interested in deploying AlwaysOn Availability Groups. And this demand will grow further in the future, because Availability Groups will be part …
How to ruin your High Availability solution by using Virtualization + read more
