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
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
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
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 …
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.
