SQL Server Quickie #31 – Database Snapshots
Today I have uploaded SQL Server Quickie #31 to YouTube. This time I’m talking about Database Snapshots in SQL Server. Thanks for your time, -Klaus
Table Ordering for Joins
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 …
Announcing the *brand new* SQLpassion Briefings and new SQLpassion Workshops
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
SQL Server Quickie #30 – the Transaction Isolation Level Snapshot Isolation
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
Performance Monitoring with SQL Server
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 …
