Business Intelligence, SQLServerPedia Syndication

Partitioning Summary: SQL Server 2005 vs SQL Server 2008

Sometimes, I hear some refusals to upgrade from SQL Server 2005 to SQL Server 2008 on the grounds that ‘2005 is working fine, so we don’t need to upgrade – I’ll keep this ticking over until it fails’.That might be suitable for some environments, but what happens in the case where the database is growing… Continue reading Partitioning Summary: SQL Server 2005 vs SQL Server 2008

Business Intelligence

Indexing: Fact and Dimension guidelines

Indexing is part of the art of optimising the database structure. However, there are no real 'hard and fast' rules since it depends, ultimately, on query use.  Here are some suggestions below:Dimension tablesDimension tables should have a clustered primary key index. This assumes that there is a surrogate primary key as per Kimball's advice.Dimension tables… Continue reading Indexing: Fact and Dimension guidelines