Columnstore Indexing at SQL Saturday #104
SQL Server 2012 will give us more index options by adding the Columnstore index. This post is an overview of this new feature, and it’s also a prelude to the presentation I’m delivering on Columnstore indexing January 7, 2011 at SQL Saturday #104 in Colorado Springs, CO. My presentation, Using Columnstore Indexes in SQL Server [...]
Query a Star Schema for Trends over Time
A data mart in the form of star schema provides us with a powerful but easy way to develop SQL for metrics and reports. The typical query will get data from a fact table, join to one or more dimensions, and perform some grouping and aggregations. Very quickly the foundation for a new report can [...]
Welcome to my blog! I write mostly about Business Intelligence. I'm speaking at SQL Rally in Dallas on May 10-11.
