Microsoft® SQL Server® 2012: Pocket Consultant

Chapter 9. Using Indexes, Constraints, and Partitions

• Creating and Managing Indexes

• Working with Columnstore Indexes

• Column Constraints and Rules

• Creating Partitioned Tables and Indexes

• Compressing Tables, Indexes, and Partitions

Just as a fundamental understanding of schemas, tables, and views is essential for success as a database administrator, so is an understanding of indexes, constraints, and partitions. At their most basic, indexes, constraints, and partitions are control elements:

• Indexes provide faster access to data because you do not need to search an entire table to get desired results.

• Constraints control the way column values are used so you can be sure that columns contain acceptable values.

• Partitions allow you to manage subsets of data ...