Là một người viết về một khu vực rất cao, nhưng hạn chế, trong SQL Server, tôi frequentlyasked do độc giả của tôi những gì họ có thể đọc để chuẩn bị cho việc đọc sách của tôi. Bây giờ tôi có một câu trả lời không chỉ cho độc giả của tôi, nhưng đối với bản thân mình là tốt. | Contents Level 2 Read Committed .1392 Level 3 Repeatable Read .1392 Level 4 Serializable .1395 Snapshot isolations .1399 Using locking hints .1402 Application Locks .1403 Application Locking Design .1405 Implementing optimistic locking .1405 Lost updates .1405 Transaction-Log Architecture .1408 Transaction log sequence .1408 Transaction log recovery .1412 Transaction Performance Strategies .1413 Evaluating database concurrency performance .1413 Summary .1414 Chapter 67 Data Understanding Data Compression .1415 Data compression pros and cons .1416 Row compression .1417 Page compression .1417 Compression sequence .1420 Applying Data Compression .1421 Determining the current compression setting .1421 Estimating data compression .1422 Enabling data compression .1422 Data compression strategies .1424 Summary .1425 Chapter 68 Partitioning Strategies .1428 Partitioned Views .1429 Local-partition views .1430 Distributed-partition views .1438 Partitioned Tables and Indexes .1440 Creating the partition function .1441 Creating partition schemes .1443 Creating the partition table .1444 Querying partition tables .1445 Altering partition tables .1446 Switching tables .1447 Rolling partitions .1449 Indexing partitioned tables .1449 Removing partitioning .1450 Data-Driven Partitioning .1450 Summary .1451 Chapter 69 Resource Configuring Resource Governor .1454 Resource pools .1454 Workload groups .1456 Classifier functions .1457 Monitoring Resource Governor .1457 Summary .1458 Part X Business Intelligence Chapter 70 BI DataWarehousing .1462 Star schema .1462 Snowflake schema .1463 Surrogate keys .1464 Consistency .1464 Loading data .1465 Changing data in dimensions .1467 Summary .1468 xxx Contents Chapter 71 Building Multidimensional Cubes with Analysis Analysis Services Quick Start .1469 Analysis Services Architecture .1470 Unified Dimensional Model .1471 Server .1471 Client .1472 .
