Microsoft® SQL Server® 2012 Bible

1107 Chapter 48: Data Compression 48 if suffi cient CPU overhead is available on your system, you can holistically page compress ...

1108 Part VIII: Performance Tuning and Optimization FROM sys.dm_db_index_operational_stats (db_id(), NULL, NULL, NULL) i JOIN sy ...

1109 CHAPTER 49 Partitioning IN THIS CHAPTER Scaling Out with Multiple Tables and Multiple Servers Using Distributed Partition V ...

1110 Part VIII: Performance Tuning and Optimization Best Practice Large, frequently accessed tables, with data that can logicall ...

1111 Chapter 49: Partitioning 49 The individual tables underneath the partitioned view are called member tables, not to be confu ...

1112 Part VIII: Performance Tuning and Optimization They differ from the original tables only in the primary-key defi nition, wh ...

1113 Chapter 49: Partitioning 49 OrderQty int NOT NULL, UnitPrice money NOT NULL, CarrierTrackingNumber varchar(25) NOT NULL ) O ...

1114 Part VIII: Performance Tuning and Optimization sod.CarrierTrackingNumber FROM Sales.SalesOrderDetail sod INNER JOIN dbo.Sal ...

1115 Chapter 49: Partitioning 49 scalability. Even though the view’s union includes all three partition tables, the query execut ...

1116 Part VIII: Performance Tuning and Optimization FIGURE 49-2 When a query with a WHERE clause restriction that includes the p ...

1117 Chapter 49: Partitioning 49 Partitioned Tables and Indexes Partitioned tables are similar to partitioned views — both invol ...

1118 Part VIII: Performance Tuning and Optimization Create the partition scheme that assigns partitions to fi legroups. Create ...

1119 Chapter 49: Partitioning 49 GO ALTER DATABASE AdventureWorks ADD FILEGROUP AdventureWorks_SalesOrderDetail2006Partition GO ...

1120 Part VIII: Performance Tuning and Optimization GO ALTER DATABASE AdventureWorks ADD FILEGROUP AdventureWorks_SalesOrderDeta ...

1121 Chapter 49: Partitioning 49 CREATE PARTITION FUNCTION fnOrderYears(DateTime) AS RANGE LEFT FOR VALUES ('12/31/2005', '12/31 ...

1122 Part VIII: Performance Tuning and Optimization For information about partition schemes programmatically, query sys.partitio ...

1123 Chapter 49: Partitioning 49 LineTotal, ModifiedDate FROM Sales.SalesOrderDetail Multiple partition schemes can share a sing ...

1124 Part VIII: Performance Tuning and Optimization Altering Partition Tables For partition tables to be updated to keep up with ...

1125 Chapter 49: Partitioning 49 Switching Tables Switching tables is the cool capability to move an entire table into a partiti ...

1126 Part VIII: Performance Tuning and Optimization ADD CONSTRAINT SalesOrderDetailNewPK PRIMARY KEY NONCLUSTERED (SalesOrderDet ...