On May 11th I will deliver a precon about SQL Server 2014 Performance Improvements at the SQLDay Poland conference in Wroclaw/Poland. I have already done intensive work on SQL Server 2014 and helped various customers around Europe to move their workload to SQL Server 2014. In this precon I will talk about the various performance …
Learn about SQL Server 2014 Performance Improvements + read more
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
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
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 …
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
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
