SQL Server Quickie #22 – The Buffer Pool
Today I have uploaded the 22th SQL Server Quickie to YouTube. This time I’m talking about the Buffer Pool in SQL Server. Thanks for watching! -Klaus
The 3 Configuration Options that you always have to change in SQL Server!
You install your brand-new SQL Server using the installation wizard, and at the very end you hit the Finish button. Woohoo – now we can go into production with our server! Sorry, but that’s not really the truth, because your brand-new SQL Server is misconfigured by default! Yes, you read that correctly: a default installation …
The 3 Configuration Options that you always have to change in SQL Server! + read more
INTERSECT ALL in SQL Server
In my previous blog posting I talked about the basics of the INTERSECT set operation in SQL Server, what the differences are compared with an INNER JOIN, and why you need a very good supporting indexing strategy. Today I want to talk about the INTERSECT ALL operator that is not implemented in SQL Server. INTERSECT …
INTERSECT in SQL Server
In today’s blog posting I want to talk about the INTERSECT set operation in SQL Server. The INTERSECT set operation intersects two sets with each other and returns the rows that appear with identical column values in both sets. The following picture illustrates this concept. INTERSECT vs. Inner Join As you will realize, it is …
In-Memory OLTP (Hekaton) and Sort Warnings
In-Memory OLTP is all about In-Memory. But that’s only half the truth. In today’s blog posting I want to show you that even In-Memory OLTP can cause disk activity when you just read data from memory. The problem here is inaccurate statistics in combination with explicit sort operators in the execution plan. The problem with …
