It happens very often these days: people contact me because they want some help from me in designing their High Availability solution for SQL Server. There are already a lot of people who are interested in deploying AlwaysOn Availability Groups. And this demand will grow further in the future, because Availability Groups will be part …
How to ruin your High Availability solution by using Virtualization + read more
Today I have uploaded SQL Server Quickie #32 to YouTube. This time I’m talking about the difference between Temp Tables and Table Variables in SQL Server. Thanks for your time, -Klaus
At the beginning of my SQL Server Performance Tuning Workshop I always start by giving a general overview of what happens within SQL Server when we execute a query. Executing a SELECT query is quite simple, but executing a DML statement is more complex, because SQL Server has to change the corresponding page in memory, …
How the CHECKPOINT process deals with uncommitted transactions + read more
I’m a SQL Server performance troubleshooter. I make a living out of SQL Server problems. Sounds crazy, but a lot of people approach me every month with various performance related problems that they can’t explain, but which they have to resolve. And a lot of time I hear from them that yesterday the performance of …
Performance Troubleshooting with the Query Store in SQL Server 2016 + read more
SQL Server Availability Groups were introduced back with SQL Server 2012. They are an awesome replacement for Database Mirroring (introduced back with SQL Server 2005 SP1), but with one huge limitation: the nodes on which the replicas are hosted must be part of the same Windows cluster. This doesn’t sound that at first, but a …
How to create a SQL Server Availability Group WITHOUT an Active Directory Domain + 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.
