SQL Server Quickie #41 – Recovery Mode SIMPLE
Today I have published SQL Server Quickie #41 on YouTube. This time I’m talking about the Recovery Mode SIMPLE in SQL Server. Thanks for your time, -Klaus
Disabling ROW and PAGE Level Locks in SQL Server
Today I want to talk about another very interesting topic in SQL Server: disabling Row and Page Level Locks in SQL Server. Every time that you rebuild an Index in SQL Server, you can use the ALLOW_ROW_LOCKS and ALLOW_PAGE_LOCKS options to specify that SQL Server should acquire Row and Page Level Locks when accessing your …
Disabling ROW and PAGE Level Locks in SQL Server + read more
Latch Coupling in SQL Server
Years ago I blogged about Latches and why they are needed by SQL Server. In today’s blog post I want to concentrate a little bit more on the Buffer Latches (BUF), and how they are used by SQL Server during Index Seek Operations. Here you will learn a concept called Latch Coupling. Index Seek Operations …
How many NUMA Nodes do I have?
A question that I get asked very often during my various SQL Server Consulting engagements is on how many NUMA nodes SQL Server is running on. Therefore I want to show you in today‘s blog post a few ways and techniques to find out how many NUMA nodes your SQL Server has. For a general …
SQL Server Quickie #40 – ColumnStore Indexes
Today I have uploaded SQL Server Quickie #40 to YouTube. This time I’m talking about ColumnStore Indexes in SQL Server. Thanks for your time, -Klaus
