Presenter: Andy Novick of Novick Software
Topic: Partitioning Techniques
Partitioning techniques in SQL Server help the developer and DBA manage large quantities of data and improve query performance in a variety of situations. This presentation demonstrates the techniques used for
Partitioned Tables
Partitioned Views
Partition aligned Indexed Views
Reasons for partitioning in both OLTP and data warehouse applications will be disused along with these topics:
Partitioning Basics
Hash Partitioning
Aligned vs. unaligned indexes
Index Views Basic
Index placement in Aligned and unaligned partitioning
The topics include features from SQL Server 2000, 2005 and new features from 2008. Come learn about these powerful schema design techniques.
Biography:
Biography:Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience. His consulting practice focuses on building applications, including software products that use SQL Server’s capabilities to the maximum. He has developed both OLTP and data warehouse databases with multi-terabytes scale. He has particular expertise in automating data management for such large databases. Other recent projects have included ETL, Security and SQL Injection prevention. Andy is the originator of the popular “SQL Server Load-fest” event conduced in Waltham, MA.