Microsoft® SQL Server® 2012 Bible

1127 Chapter 49: Partitioning 49 NEXT USED [AdventureWorks_SalesOrderDetail2009Partition] GO ALTER PARTITION FUNCTION pfyearsfnO ...

1128 Part VIII: Performance Tuning and Optimization Rolling partitions are useful for time-based partition functions such as par ...

1129 Chapter 49: Partitioning 49 Summary Not every database needs to scale to higher magnitudes of capacity, but when a project ...

c49.indd 1130c49.indd 1130 7/31/2012 10:24:25 AM7/31/2012 10:24:25 AM http://www.it-ebooks.info ...

1131 CHAPTER 50 Resource Governor IN THIS CHAPTER Understanding Fundamentals Using Performance Monitoring of the Resource Govern ...

1132 Part VIII: Performance Tuning and Optimization Exploring the Fundamentals of the Resource Governor The Resource Governor re ...

1133 Chapter 50: Resource Governor 50 Minimum Rate for any resource pool. This example illustrates how resources can share when ...

1134 Part VIII: Performance Tuning and Optimization CREATE RESOURCE POOL CustomPool1 WITH (MAX_CPU_PERCENT = 30); GO ALTER RESOU ...

1135 Chapter 50: Resource Governor 50 Select New Resource Pool; a dialog box appears. Scroll to the bottom of the Resource Pool ...

1136 Part VIII: Performance Tuning and Optimization Workload Group To keep the assignment of resource pools manageable and to al ...

1137 Chapter 50: Resource Governor 50 map to the specifi ed user or application names, the function assigns them to the default ...

1138 Part VIII: Performance Tuning and Optimization Classifi er Function SQL Server sessions are assigned to workload groups, wh ...

1139 Chapter 50: Resource Governor 50 FIGURE 50-2 Performance Monitor enables you to know how the resource pools function. While ...

1140 Part VIII: Performance Tuning and Optimization Views and Limitations Following are three catalog views for the Resource gov ...

Part IX Business Intelligence IN THIS PART Chapter 51 Business Intelligence Database Design Chapter 52 Building, Deploying, and ...

c51.indd 1142c51.indd 1142 7/31/2012 10:28:40 AM7/31/2012 10:28:40 AM http://www.it-ebooks.info ...

1143 CHAPTER 51 Business Intelligence Database Design IN THIS CHAPTER Understanding Data Warehousing Concepts Understanding Ware ...

1144 Part IX: Business Intelligence that acts as the source for OLAP. The result of coupling these two is typically a cube, whic ...

1145 Chapter 51: Business Intelligence Database Design 51 Because the business has an intimate relationship with the data and wo ...

1146 Part IX: Business Intelligence when designing dimensions a new column, a surrogate key, will be added to each table. This c ...