In today’s blog post I want to talk about a very interesting topic in SQL Server: whether or not it makes sense to rearrange the tables in a join in a specific order. Every time that I do a presentation about query and performance tuning, people ask me if they should arrange the tables in …
Wow, time flies by. Over the last 3 months I was almost all the time on the road, traveling around the world, speaking and consulting about SQL Server. December is almost every year already a very silent month for me, and I enjoy it a lot staying at home without seeing any airplanes anymore 🙂 …
Announcing the *brand new* SQLpassion Briefings and new SQLpassion Workshops + read more
Today I have uploaded the 30th SQL Server Quickie to YouTube. This time I’m talking about the transaction isolation level Snapshot Isolation in SQL Server. Thanks for your time, -Klaus
Imagine you have a well-performing SQL Server. I know that this scenario is almost unbelievable but sometimes it happens. To make sure that your SQL Server remains healthy in the future you have to establish performance monitoring techniques. With this blog posting I want to give you a quick overview about performance monitoring with SQL …
Around 8 months ago I wrote a blog posting where I discussed the various reasons why I don’t yet recommend In-Memory OLTP to my customers. A lot of people are approach me these days because they have some performance problems and they are thinking about using In-Memory OLTP to solve them. As we all know, …
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.
