Microsoft SQL Server 2008 R2 Unleashed- P3:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | xx Adding and Dropping Table Switching Table Creating Temporary 25 Creating and Managing Indexes 791 What s New in Creating and Managing Types of Clustered Nonclustered Creating Creating Indexes with Creating Indexes with Managing Managing Indexes with Managing Indexes with Dropping Online Indexing Indexes on 26 Implementing Data Integrity 811 What s New in Data Types of Data Domain Entity Referential Enforcing Data Implementing Declarative Data Implementing Procedural Data Using The PRIMARY KEY The UNIQUE The FOREIGN KEY Referential Integrity The CHECK Creating Managing Declarative Bound When a Default Is Restrictions on Download from Contents xxi 27 Creating and Managing Views in SQL Server 837 What s New in Creating and Managing Definition of Using Simplifying Data Focusing on Specific Abstracting Controlling Access to Creating Creating Views Using Creating Views Using the View Managing Altering Dropping Views with Managing Views with Data Modifications and Partitioned Modifying Data Through a Partitioned Distributed Partitioned Indexed Creating Indexed Indexed Views and To Expand or Not to 28 Creating and Managing Stored Procedures 869 What s New in Creating and Managing Stored .
