It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free over the next few months.
Tomorrow I’m teaching Fundamentals of Columnstore, and we’re going to be covering the internals of how SQL Server and Azure SQL DB store data in columnstore indexes. You’ll learn why people think it’s an index on every column, but in reality, it’s something wildly different.
There’s a lot more to cover in columnstore, like how columnstore indexes are rebuilt, why it’s so important to do index maintenance on columnstore indexes (unlike rowstore), the differences between clustered and nonclustered