SQL Server Quickie #17 – Round Robin Allocations
Today I have uploaded the 17th SQL Server Quickie to YouTube. This time I’m talking about Round Robin Allocations operations in SQL Server. Thanks for watching! -Klaus
The dangerous beauty of the PIVOT operator in SQL Server
In today’s blog posting I want to discuss one specific T-SQL language construct in SQL Server – the PIVOT operator that was introduced back with SQL Server 2005. I always refer to this language construct as one of the most dangerous ones in SQL Server – and you will very soon see why. Before we …
The dangerous beauty of the PIVOT operator in SQL Server + read more
Database Shrink: NOTRUNCATE vs. TRUNCATEONLY
Two weeks ago I published my latest SQL Server Quickie, which covered the basics of Database Shrink operations in SQL Server, and why you should never ever use them. After the release of the Quickie, I got really good feedback on it, and one interesting question was about the additional NOTRUNCATE and TRUNCATEONLY options that …
SQL Server Quickie #16 – Database Shrink Operations
Today I have uploaded the 16th SQL Server Quickie to YouTube. This time I’m talking about Database Shrink operations in SQL Server. Thanks for watching! -Klaus
Why do we need UPDATE Locks in SQL Server?
Today I want to talk about a specific question that I almost get every time when I teach about Locking & Blocking in SQL Server: Why does SQL Server need to have Update Locks? Before we go down to the details of why they are needed, I first want to give you a basic overview …
