Microsoft SQL Server 2008 R2 Unleashed- P3

- 25 Creating and Managing Indexes 791 What’s New in Creating and Managing Indexes .
- Clustered Indexes ...792.
- Nonclustered Indexes ...793.
- Creating Indexes with SSMS...800.
- Managing Indexes with SSMS ...806.
- Dropping Indexes ...807.
- Indexes on Views ...809.
- 26 Implementing Data Integrity 811 What’s New in Data Integrity...811.
- Referential Integrity...812.
- Summary ...836.
- ptg 27 Creating and Managing Views in SQL Server 837.
- What’s New in Creating and Managing Views .
- Altering Views ...852.
- Managing Views with SSMS ...853.
- Creating Indexed Views...861.
- Indexed Views and Performance...863.
- Summary ...867.
- 28 Creating and Managing Stored Procedures 869 What’s New in Creating and Managing Stored Procedures...869.
- Advantages of Stored Procedures.
- Creating Stored Procedures.
- Temporary Stored Procedures .
- Executing Stored Procedures...880.
- Identifying Objects Referenced in Stored Procedures...887.
- Viewing Stored Procedures .
- Modifying Stored Procedures.
- Viewing and Modifying Stored Procedures with SSMS...892.
- Debugging Stored Procedures Using SQL Server Management Studio ...905.
- Using System Stored Procedures...908.
- 29 Creating and Managing User-Defined Functions 917 What’s New in SQL Server .
- Types of User-Defined Functions.
- Scalar Functions...921.
- Table-Valued Functions ...923.
- Creating and Managing User-Defined Functions.
- Creating User-Defined Functions ...925.
- Viewing and Modifying User-Defined Functions ...936.
- Rewriting Stored Procedures as Functions.
- Creating and Using CLR Functions ...944.
- Summary ...947.
- 30 Creating and Managing Triggers 949 What’s New in Creating and Managing Triggers ...950.
- Creating DML Triggers...951.
- Enforcing Referential Integrity by Using DML Triggers ...961.
- INSTEAD OF Triggers ...967.
- Creating DDL Triggers ...983.
- Managing DDL Triggers...986.
- Using CLR Triggers...988.
- Using Nested Triggers ...991.
- Using Recursive Triggers ...992.
- What’s New in Transaction Management .
- How SQL Server Manages Transactions.
- AutoCommit Transactions ...997.
- Explicit User-Defined Transactions ...998.
- Implicit Transactions Versus Explicit Transactions...1006.
- Transactions and Stored Procedures ...1009.
- Triggers and Multistatement Transactions ...1017.
- READ_COMMITTED_SNAPSHOT Isolation ...1022.
- Long-Running Transactions...1037.
- 32 Database Snapshots 1043 What’s New with Database Snapshots ...1044.
- What Are Database Snapshots.
- Security for Database Snapshots...1067.
- Summary ...1068.
- 33 Database Maintenance 1069 What’s New in Database Maintenance.
- Part V SQL Server Performance and Optimization 34 Data Structures, Indexes, and Performance 1091 What’s New for Data Structures, Indexes, and Performance ...1092.
- Index Pages ...1112.
- Clustered Indexes ...1133.
- Nonclustered Indexes ...1136.
- Data Modification and Performance .
- Index Statistics ...1153.
- SQL Server Index Maintenance .
- Disabling Indexes ...1182.
- Managing Indexes with SSMS ...1183.
- Wide Indexes Versus Multiple Indexes ...1191.
- Indexed Views ...1192.
- Creating and Using Filtered Indexes...1196.
- Creating and Using Filtered Statistics .
- Identifying Unused Indexes ...1205.
- 35 Understanding Query Optimization 1209 What’s New in Query Optimization...1210.
- Optimizing with Indexed Views ...1236.
- Summary ...1300.
- 36 Query Analysis 1301 What’s New in Query Analysis ...1302.
- Analyzing Stored Procedures ...1315.
- Query Analysis with SQL Server Profiler .
- 37 Locking and Performance 1341 What’s New in Locking and Performance...1341.
- Transaction Isolation Levels in SQL Server ...1342.
- Read Committed Snapshot Isolation ...1345.
- Monitoring Lock Activity in SQL Server .
- Viewing Locking Activity with SQL Server Profiler ...1355.
- SQL Server Lock Types .
- SQL Server Lock Granularity .
- Summary ...1401.
- 38 Database Design and Performance 1403 What’s New in Database Design and Performance .
- Database Filegroups and Performance.
- SQL Server and SAN Technology .
- SAN Considerations for SQL Server ...1423.
- Summary ...1425.
- 39 Monitoring SQL Server Performance 1427 What’s New in Monitoring SQL Server Performance...1428.
- SQL Server Utility .
- SQL Server Extended Events.
- Monitoring SQL Server’s Disk Activity...1490.
- Monitoring Other SQL Server Performance Items...1492.
- Summary ...1492

Xem thử không khả dụng, vui lòng xem tại trang nguồn
hoặc xem Tóm tắt