SQL Server Quickie #15 – Merge Join Operator
Today I have uploaded the 15th SQL Server Quickie to YouTube. This time I’m talking about the Merge Join Operator in SQL Server. Thanks for watching! -Klaus
SQLServer
Introduction to Spinlocks in SQL Server
In last weeks blog posting I have talked about Latches in SQL Server. At the end I have also introduced a little bit the idea of spinlocks to you. Based on that foundation I will continue today the discussion about spinlocks in SQL Server, and will show you how you can troubleshoot them. Why do …
Introduction to Latches in SQL Server
In today’s blog posting I want to talk about a more advanced, low-level synchronization object used by SQL Server: Latches. A latch is a lightweight synchronization object used by the Storage Engine of SQL Server to protect internal memory structures that can’t be accessed in a true multi-threaded fashion. In the first part of the …
SQL Server Performance Tuning & Troubleshooting Workshop in Antwerpen/Belgium
I’m very happy to announce today that I also run my famous SQL Server Performance Tuning & Troubleshooting Workshop from November 24 – 28 in Antwerpen/Belgium. Here’s the outline of the workshop: “Are you an SQL Server DBA or developer and you have encountered performance related problems with SQL Server? Yesterday your SQL Server was …
SQL Server Performance Tuning & Troubleshooting Workshop in Antwerpen/Belgium + read more
Configuring the In-Memory OLTP File Group for High Performance
In todays’ blog posting I want to talk about the memory optimized file group used by In-Memory OLTP to achieve durability, and how to configure it for high performance throughput. Before we go down to the details, I want to give you a brief overview of how In-Memory OLTP achieves durability with this specialized file …
Configuring the In-Memory OLTP File Group for High Performance + read more
