Đang chuẩn bị liên kết để tải về tài liệu:
Microsoft SQL Server 2008 R2 Unleashed- P3

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 releases.Microsoft SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | xx Adding and Dropping Table Partitions.782 Switching Table Partitions.785 Creating Temporary Tables.789 Summary.790 25 Creating and Managing Indexes 791 What s New in Creating and Managing Indexes.791 Types of Indexes.792 Clustered Indexes.792 Nonclustered Indexes.793 Creating Indexes.795 Creating Indexes with T-SQL.795 Creating Indexes with SSMS.800 Managing Indexes.803 Managing Indexes with T-SQL.803 Managing Indexes with SSMS.806 Dropping Indexes.807 Online Indexing Operations.807 Indexes on Views.809 Summary.810 26 Implementing Data Integrity 811 What s New in Data Integrity.811 Types of Data Integrity.812 Domain Integrity.812 Entity Integrity.812 Referential Integrity.812 Enforcing Data Integrity.812 Implementing Declarative Data Integrity.812 Implementing Procedural Data Integrity.813 Using Constraints.813 The PRIMARY KEY Constraint.813 The UNIQUE Constraint.815 The FOREIGN KEY Referential Integrity Constraint.816 The CHECK Constraint.820 Creating Constraints.821 Managing Constraints.827 Rules.830 Defaults.831 Declarative Defaults.831 Bound Defaults.833 When a Default Is Applied.833 Restrictions on Defaults.835 Summary.836 Download from www.wowebook.com Contents xxi 27 Creating and Managing Views in SQL Server 837 What s New in Creating and Managing Views.837 Definition of Views.837 Using Views.839 Simplifying Data Manipulation.839 Focusing on Specific Data.840 Abstracting Data.841 Controlling Access to Data.842 Creating Views.844 Creating Views Using T-SQL.845 Creating Views Using the View Designer.849 Managing Views.852 Altering Views.852 Dropping Views with T-SQL.853 Managing Views with SSMS.853 Data Modifications and Views.853 Partitioned Views.854 Modifying Data Through a Partitioned View.858 Distributed Partitioned Views.859 Indexed Views.860 Creating Indexed Views.861 Indexed Views and Performance.863 To Expand or Not to Expand.866 Summary.867 28 Creating and Managing Stored Procedures 869 What s New in Creating and Managing Stored Procedures.869 .