Have you ever wanted to perform aggregations across multiple columns/dimensions in SQL Server without licensing SSAS (SQL Server Analysis Services)? I am not talking about using the Developer edition in production, nor am I talking about installing a pirate copy of SQL Server. Mission Impossible? Not really, because it’s possible through the so-called Grouping Sets …
In today’s blog posting I want to talk about a very specific performance problem that can occur on heap tables: Forwarding Records. First of all we have to clarify what a heap table is: a heap table is just a table without a Clustered Index. It is very fast for inserting new records, and very …
I travel a lot. I’m away from home a lot. I spread the passion about SQL Server around the whole world through my conference talks, and my public trainings. Currently I am sitting in Cape Town/South Africa and writing these lines to you. Because of my huge travel schedule and my passion about SQL Server, …
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
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
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.
