SQLServer

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 …

Database Shrink: NOTRUNCATE vs. TRUNCATEONLY + read more