SQL Server Quickie #23 – Plan Cache Pollution
Today I have uploaded the 23th SQL Server Quickie to YouTube. This time I’m talking about Plan Cache Pollution in SQL Server. Thanks for watching! -Klaus
SQLServer
Latches, Spinlocks & Lock-Free Data Structures Recording
A few weeks ago I have spoken at the SQLRally Nordic conference in Copenhagen about Latches, Spinlocks, and Lock-Free Data Structures in SQL Server. Fortunately my 2.5 hour long non-stop session was recorded, and is now finally available at Youtube for watching. Enjoy! -Klaus
Statistics on UNIQUEIDENTIFIER columns
During the SQLRally conference in Copenhagen/Denmark, Brent Ozar (Blog, Twitter) and I had a very interesting conversation regarding Statistics on UNIQUEIDENTIFER columns. It seems that SQL Server shows some very nasty behavior here. Let’s have a look. The repro To show you the behavior we have complained about, I created a new database with the …
Why I don’t (yet) recommend In-Memory OLTP to my customers
Ok, some of you will hate me after this blog posting, but it has to be said. Over the last months I have done a lot of work in the area of In-Memory OLTP, and I also had a lot of customer requests regarding this amazing new technology. Unfortunately none of them were really excited …
Why I don’t (yet) recommend In-Memory OLTP to my customers + read more
Transaction Logging in In-Memory OLTP (Hekaton)
In today’s blog posting I want to talk in more detail about how In-Memory OLTP logs transaction log records into the transaction log. As you might know, In-Memory OLTP offers you 2 durability options for your Memory Optimized Tables: SCHEMA_ONLY SCHEMA_AND_DATA I don’t want to talk more about SCHEMA_ONLY today, because with this option no …
