SQL Server Sparse Columns

SQL Server Sparse Column Often stored in the columns of a reporting database are troublesome columns that are populated with limited amounts of data.  One method to optimize these types of columns in your reporting database is to utilize the SPARSE keyword in a CREATE or ALTER table statement.  For instance to mark the Product … [Read more…]

SQL Server Index Performance for BI Databases

SQL Server Index Performance Tips for Business Intelligence If you are new to Reporting Databases you need to be aware that they indexing needs are different from OLTP database operations.  While you will still have clustered and nonclustered indexes how you utilize them will be different with Reporting systems. Having a lot of indexes on … [Read more…]