Data Management and Indexing Options for SQL Server Data Warehouses

Thanks to everyone that attended my presentation at Atlanta MDF last night. It was great meeting some new people after the talk, and it seemed like it was well received. Here are the links to the slidedeck and demo scripts. Remember, the scripts were written for AdventureWorksDW for SQL Server 2012.

Also, I included the links section below as well because it’s a handy reference that I will continue to use in the future 🙂

If anyone has any questions or additional comments (even constructive criticisms) I’d love to hear from you. Comment below, or reach out via Twitter or LinkedIn.


DATA WAREHOUSE

Microsoft EDW Architecture, Guidance and Deployment Best Practices
http://msdn.microsoft.com/en-us/library/hh147624.aspx

The Data Loading Performance Guide
http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx

Top 10 Best Practices for Building a Large Scale Relational Data Warehouse
http://sqlcat.com/sqlcat/b/top10lists/archive/2008/02/06/top-10-best-practices-for-building-a-large-scale-relational-data-warehouse.aspx

PARTITIONED TABLES

Partitioned Table and Index Strategies Using SQL Server 2008
http://technet.microsoft.com/en-us/library/dd578580%28v=sql.100%29.aspx

Strategies for Partitioning Relational Data Warehouses in Microsoft SQL Server
http://technet.microsoft.com/en-us/library/cc966457.aspx

Table Partitioning Resources
http://www.brentozar.com/sql/table-partitioning-resources/

Query Processing Enhancements on Partitioned Tables and Indexes
http://msdn.microsoft.com/en-us/library/ms345599.aspx

INDEXED VIEWS

Creating Indexed Views (long list of restrictions)
http://msdn.microsoft.com/en-us/library/ms191432.aspx

Partition Switching with Indexed Views
http://technet.microsoft.com/en-us/library/bb964715(v=sql.105).aspx

FILTERED INDEXES

Filtered Index Design Guidelines
http://msdn.microsoft.com/en-us/library/cc280372(v=sql.100).aspx

DATA COMPRESSION

Data Compression: Strategy, Capacity Planning and Best Practices
http://msdn.microsoft.com/en-us/library/dd894051%28v=sql.100%29.aspx

COLUMNSTORE INDEXES (SQL 2012)

Columnstore Indexes BOL
http://msdn.microsoft.com/en-us/library/gg492088.aspx

Columnstore Internals
http://rusanu.com/2012/05/29/inside-the-sql-server-2012-columnstore-indexes/

SQL Server Columnstore Performance Tuning
http://social.technet.microsoft.com/wiki/contents/articles/4995.sql-server-columnstore-performance-tuning.aspx

CLUSTERED COLUMNSTORE INDEXES (SQL 2014)

Clustered Columnstore Internals
http://rusanu.com/2013/06/11/sql-server-clustered-columnstore-indexes-at-teched-2013/

Improvements in Batch-mode support (TechEd Video)
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B322#fbid=rAFPjiEmlNt

Data Management and Indexing Options for SQL Server Data Warehouses