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
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 …
After speaking at the SQLRally conference in Copenhagen earlier this week, my next stop was at the SQLBits conference in London, where I have presented 2 sessions: In-Memory OLTP Deadlocking As promised at the end of both sessions, you can download the slides & samples for your further reference. If you are interested in learning …
In-Memory OLTP & Deadlocking – my SQLBits sessions + read more
Whew, this was an intensive session about Latches, Spinlocks & Lock-Free Data Structures at the SQLRally Nordic conference in Copenhagen. I hope you have enjoyed this session as much as I have enjoyed it to present it in front of a fully packed room – with an engaging audience 🙂 As promised at the end …
Latches, Spinlocks & Lock-Free Data Structures – my SQLRally Nordic session + 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.
