SQL Server Quickie #32 – Temp Tables vs. Table Variables
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
How the CHECKPOINT process deals with uncommitted transactions
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
Performance Troubleshooting with the Query Store in SQL Server 2016
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
How to create a SQL Server Availability Group WITHOUT an Active Directory Domain
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
Come to SQLBits, and learn about Locking & Blocking
I’m delighted to announce that I have been chosen to present a precon about Locking & Blocking in SQL Server at SQLBits on May 5 in Liverpool/United Kingdom. As you might know I really enjoy talking about locking & blocking, because it’s one of my specialities. And I’m also already a veteran (with almost no …
Come to SQLBits, and learn about Locking & Blocking + read more
