深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作

深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
分享
扫描下方二维码分享到微信
打开微信,点击右上角”+“,
使用”扫一扫“即可将网页分享到朋友圈。
作者: [美]
2009-09
版次: 1
ISBN: 9787115211439
定价: 99.00
装帧: 平装
开本: 16开
纸张: 胶版纸
页数: 754页
字数: 931千字
正文语种: 英语
原版书名: Microsoft SQL Server 2008 Internals
18人买过
  •   《深入解析SQLServer2008(英文版)》是讲述SQLServer关系数据库引擎内部机理和架构的权威指南。书中详细阐述了SQLServer处理查询、管理数据的相关内容,包括SQLServer架构和配置、跟踪/扩展事件、日志和恢复、索引、表格、查询优化、事务/并发以及DBCC。
      《深入解析SQLServer2008(英文版)》适合中高级数据库开发人员阅读。   KalenDelanay世界知名的SQLServer专家。微软SQLSewerMVP。从1987年供职Sybase时与微软合作开发最早的SQLServer版本算起。她的SQLSewer研发经验已达20多年。她本人以对SQLServer底层技术的精湛造诣享誉业内。所著InsideMicrosoftSQLServer系列(本书前身)长期以来被奉为圣经级著作。
      PaulS.Randal和KJmberlyL.Tripp夫妇世界知名的SQLServer专家。微软SQLSewerMVP。他们都曾长期效力于微软SQLSewer开发团队。Randal更是在SQLSewer多个版本中负责存储引擎的开发。
      ConorCunningham目前担任SQLSewerver引擎主架构师。负责下一代引擎的设计和开发。AdamMachanic世界知名的SQLServer专家。微软SQLServerMVP。著名社区SQLblog.com创始人。名著《SQLSewer2005编程艺术》的作者。
      BenNevarez资深D8A。有多年SQLSewer管理经验。 1 SQLServer2008ArchitectureandConfiguration 
    SQLServerEditions
    SQLServerMetadata 
    CompatibilityViews 
    CatalogViews 
    OtherMetadata 
    ComponentsoftheSQLServerEngine
    ObservingEngineBehavior
    Protocols 
    TheRelationalEngine 
    TheStorageEngine 
    TheSQLOS
    NUMAArchitecture
    TheScheduler 
    SQLServerWorkers
    BindingSchedulerstoCPUs 
    TheDedicatedAdministratorConnection(DAC) 
    Memory 
    TheBufferPoolandtheDataCache 
    AccesstoIn-MemoryDataPages 
    ManagingPagesintheDataCache 
    TheFreeBufferListandtheLazywriter 
    Checkpoints 
    ManagingMemoryinOtherCaches 
    SizingMemory 
    SizingtheBufferPool 
    SQLServerResourceGovernor 
    ResourceGovernorOverview 
    ResourceGovernorControls 
    ResourceGovernorMetadata 
    SQLServer2008Configuration 
    UsingSQLServerConfigurationManager 
    ConfiguringNetworkProtocols 
    DefaultNetworkConfiguration 
    ManagingServices 
    SQLServerSystemConfiguration 
    OperatingSystemConfiguration 
    TraceFlags 
    SQLServerConfigurationSettings 
    TheDefaultTrace 
    FinalWords 
    2 ChangeTracking,Tracing,andExtendedEvents 
    TheBasics:TriggersandEventNotifications 
    Run-TimeTriggerBehavior 
    ChangeTracking 
    ChangeTrackingConfiguration 
    ChangeTrackingRun-TimeBehavior
    TracingandProfiling
    SQLTraceArchitectureandTerminology
    SecurityandPermissions
    GettingStarted:Profiler
    Server-SideTracingandCollection
    ExtendedEvents 
    ComponentsoftheXEInfrastructure 
    EventSessions 
    ExtendedEventsDDLandQuerying 
    Summary 
    3 DatabasesandDatabaseFiles 
    SystemDatabases 
    master 
    model 
    tempdb 
    TheResourceDatabase 
    msdb 
    SampleDatabases 
    AdventureWorks 
    pubs 
    Northwind 
    DatabaseFiles 
    CreatingaDatabase 
    ACREATEDATABASEExample 
    ExpandingorShrinkingaDatabase 
    AutomaticFileExpansion 
    ManualFileExpansion 
    FastFileInitialization 
    AutomaticShrinkage 
    ManualShrinkage 
    UsingDatabaseFilegroups 
    TheDefaultFilegroup 
    AFILEGROUPCREATIONExample 
    FilestreamFilegroups 
    AlteringaDatabase 
    ALTERDATABASEExamples 
    DatabasesUndertheHood 
    SpaceAllocation 
    SettingDatabaseOptions 
    StateOptions 
    CursorOptions 
    AutoOptions 
    SQLOptions 
    DatabaseRecoveryOptions 
    OtherDatabaseOptions 
    DatabaseSnapshots 
    CreatingaDatabaseSnapshot 
    SpaceUsedbyDatabaseSnapshots 
    ManagingYourSnapshots 
    ThetempdbDatabase 
    Objectsintempdb 
    Optimizationsintempdb 
    BestPractices 
    tempdbSpaceMonitoring 
    DatabaseSecurity 
    DatabaseAccess 
    ManagingDatabaseSecurity 
    Databasesvs.Schemas 
    PrincipalsandSchemas 
    DefaultSchemas 
    MovingorCopyingaDatabase 
    DetachingandReattachingaDatabase 
    BackingUpandRestoringaDatabase 
    MovingSystemDatabases 
    MovingthemasterDatabase 
    CompatibilityLevels 
    Summary
    4 LoggingandRecovery
    TransactionLogBasics
    PhasesofRecovery
    ReadingtheLog
    ChangesinLogSize
    VirtualLogFiles
    ObservingVirtualLogFiles
    AutomaticTruncationofVirtualLogFiles
    MaintainingaRecoverableLog
    AutomaticShrinkingoftheLog
    LogFileSize
    BackingUpandRestoringaDatabase
    TypesofBackups
    RecoveryModels
    ChoosingaBackupType 
    RestoringaDatabase 
    Summary 
    5 Tables 
    CreatingTables 
    NamingTablesandColumns 
    ReservedKeywords 
    DelimitedIdentifiers 
    NamingConventions 
    DataTypes 
    MuchAdoAboutNULL 
    User-DefinedDataTypes 
    IDENTITYProperty 
    InternalStorage 
    Thesys.indexesCatalogView 
    DataStorageMetadata 
    DataPages 
    ExaminingDataPages 
    TheStructureofDataRows 
    FindingaPhysicalPage 
    StorageofFixed-LengthRows 
    StorageofVariable-LengthRows 
    StorageofDateandTimeData 
    Storageofsql_variantData 
    Constraints 
    ConstraintNamesandCatalogViewInformation 
    ConstraintFailuresinTransactionsandMultiple-RowDataModifications 
    AlteringaTable 
    ChangingaDataType 
    AddingaNewColumn 
    Adding,Dropping,Disabling,orEnablingaConstraint 
    DroppingaColumn 
    EnablingorDisablingaTrigger 
    InternalsofAlteringTables 
    HeapModificationInternals 
    AllocationStructures 
    InsertingRows 
    DeletingRows 
    UpdatingRows 
    Summary 
    6 Indexes:InternalsandManagement 
    Overview 
    SQLServerIndexB-trees 
    ToolsforAnalyzingIndexes 
    Usingthedm_db_index_physical_statsDMV 
    UsingDBCCIND 
    UnderstandingIndexStructures 
    TheDependencyontheClusteringKey 
    NonclusteredIndexes 
    ConstraintsandIndexes 
    IndexCreationOptions 
    IGNORE_DUP_KEY 
    STATISTICS_NORECOMPUTE 
    MAXDOP 
    IndexPlacement 
    ConstraintsandIndexes 
    PhysicalIndexStructures 
    IndexRowFormats 
    ClusteredIndexStructures 
    TheNon-LeafLevel(s)ofaClusteredIndex 
    AnalyzingaClusteredIndexStructure 
    NonclusteredIndexStructures 
    SpecialIndexStructures 
    IndexesonComputedColumnsandIndexedViews 
    Full-TextIndexes 
    SpatialIndexes 
    XMLIndexes 
    DataModificationInternals 
    InsertingRows 
    SplittingPages 
    DeletingRows 
    UpdatingRows 
    Table-Levelvs Index-LevelDataModification 
    Logging 
    Locking 
    Fragmentation 
    ManagingIndexStructures 
    DroppingIndexes 
    ALTERINDEX 
    DetectingFragmentation 
    RemovingFragmentation 
    RebuildinganIndex 
    Summary 
    7 SpecialStorage 
    LargeObjectStorage 
    Restricted-LengthLargeObjectData(Row-OverflowData) 
    Unrestricted-LengthLargeObjectData 
    StorageofMAX-LengthData 
    FilestreamData 
    EnablingFilestreamDataforSQLServer 
    CreatingaFilestream-EnabledDatabase 
    CreatingaTabletoHoldFilestreamData 
    ManipulatingFilestreamData 
    MetadataforFilestreamData 
    PerformanceConsiderationsforFilestreamData 
    SparseColumns 
    ManagementofSparseColumns 
    ColumnSetsandSparseColumnManipulation 
    PhysicalStorage 
    Metadata 
    StorageSavingswithSparseColumns 
    DataCompression 
    Vardecimal 
    RowCompression 
    PageCompression 
    TableandIndexPartitioning 
    PartitionFunctionsandPartitionSchemes 
    MetadataforPartitioning 
    TheSlidingWindowBenefitsofPartitioning 
    Summary 
    8 TheQueryOptimizer 
    Overview 
    TreeFormat 
    WhatIsOptimization? 
    HowtheQueryOptimizerExploresQueryPlans 
    Rules 
    Properties 
    StorageofAlternatives—The“Memo” 
    Operators 
    OptimizerArchitecture 
    BeforeOptimization 
    Simplification 
    TrivialPlan/Auto-Parameterization 
    Limitations 
    TheMemo—ExploringMultiplePlansEfficiently 
    Statistics,CardinalityEstimation,andCosting 
    StatisticsDesign 
    Density/FrequencyInformation 
    FilteredStatistics 
    StringStatistics 
    CardinalityEstimationDetails 
    Limitations 
    Costing 
    IndexSelection 
    FilteredIndexes 
    IndexedViews 
    PartitionedTables 
    Partition-AlignedIndexViews 
    DataWarehousing 
    Updates 
    HalloweenProtection 
    Split/Sort/Collapse 
    Merge 
    WideUpdatePlans 
    SparseColumnUpdates 
    PartitionedUpdates 
    Locking 
    DistributedQuery 
    ExtendedIndexes 
    Full-TextIndexes 
    XMLIndexes 
    SpatialIndexes 
    PlanHinting 
    DebuggingPlanIssues 
    {HASH|ORDER}GROUP 
    {MERGE|HASH|CONCAT}UNION 
    FORCEORDER,{LOOP|MERGE|HASH}JOIN 
    INDEX=indexname|indexid 
    FORCESEEK 
    FASTnumber_rows 
    MAXDOPN 
    OPTIMIZEFOR 
    PARAMETERIZATION{SIMPLE|FORCED} 
    NOEXPAND 
    USEPLAN 
    Summary 
    9 PlanCachingandRecompilation 
    ThePlanCache 
    PlanCacheMetadata 
    ClearingPlanCache 
    CachingMechanisms 
    AdhocQueryCaching 
    OptimizingforAdhocWorkloads 
    SimpleParameterization 
    PreparedQueries 
    CompiledObjects 
    CausesofRecompilation 
    PlanCacheInternals 
    CacheStores 
    CompiledPlans 
    ExecutionContexts 
    PlanCacheMetadata 
    Handles 
    sys.dm_exec_sql_text 
    sys.dm_exec_query_plan 
    sys.dm_exec_text_query_plan 
    sys.dm_exec_cached_plans 
    sys.dm_exec_cached_plan_dependent_objects 
    sys.dm_exec_requests 
    sys.dm_exec_query_stats 
    CacheSizeManagement 
    CostingofCacheEntries 
    ObjectsinPlanCache:TheBigPicture 
    MultiplePlansinCache 
    WhentoUseStoredProceduresandOtherCachingMechanisms 
    TroubleshootingPlanCacheIssues 
    WaitStatisticsIndicatingPlanCacheProblems 
    OtherCachingIssues 
    HandlingProblemswithCompilationandRecompilation 
    PlanGuidesandOptimizationHints 
    Summary 
    10 TransactionsandConcurrency 
    ConcurrencyModels 
    PessimisticConcurrency 
    OptimisticConcurrency 
    TransactionProcessing 
    ACIDProperties 
    TransactionDependencies 
    IsolationLevels 
    Locking 
    LockingBasics 
    Spinlocks 
    LockTypesforUserData 
    LockModes 
    LockGranularity 
    LockDuration 
    LockOwnership 
    ViewingLocks 
    LockingExamples 
    LockCompatibility 
    InternalLockingArchitecture 
    LockPartitioning 
    LockBlocks 
    LockOwnerBlocks 
    syslockinfoTable 
    Row-LevelLockingvs Page-LevelLocking 
    LockEscalation 
    Deadlocks 
    RowVersioning 
    OverviewofRowVersioning 
    RowVersioningDetails 
    Snapshot-BasedIsolationLevels 
    ChoosingaConcurrencyModel 
    ControllingLocking 
    LockHints 
    Summary 
    11 DBCCInternals 
    GettingaConsistentViewoftheDatabase 
    ObtainingaConsistentView 
    ProcessingtheDatabaseEfficiently 
    FactGeneration 
    UsingtheQueryProcessor 
    Batches 
    ReadingthePagestoProcess 
    Parallelism 
    PrimitiveSystemCatalogConsistencyChecks 
    AllocationConsistencyChecks 
    CollectingAllocationFacts 
    CheckingAllocationFacts 
    Per-TableLogicalConsistencyChecks 
    MetadataConsistencyChecks 
    PageAudit 
    DataandIndexPageProcessing 
    ColumnProcessing 
    TextPageProcessing 
    Cross-PageConsistencyChecks 
    Cross-TableConsistencyChecks 
    ServiceBrokerConsistencyChecks 
    Cross-CatalogConsistencyChecks 
    Indexed-ViewConsistencyChecks 
    XML-IndexConsistencyChecks 
    Spatial-IndexConsistencyChecks 
    DBCCCHECKDBOutput 
    RegularOutput 
    SQLServerErrorLogOutput 
    ApplicationEventLogOutput 
    ProgressReportingOutput 
    DBCCCHECKDBOptions 
    NOINDEX 
    RepairOptions 
    ALL_ERRORMSGS 
    EXTENDED_LOGICAL_CHECKS 
    NO_INFOMSGS 
    TABLOCK 
    ESTIMATEONLY 
    PHYSICAL_ONLY 
    DATA_PURITY 
    DatabaseRepairs 
    RepairMechanisms 
    EmergencyModeRepair 
    WhatDataWasDeletedbyRepair? 
    Consistency-CheckingCommandsOtherThanDBCCCHECKDB 
    DBCCCHECKALLOC 
    DBCCCHECKTABLE 
    DBCCCHECKFILEGROUP 
    DBCCCHECKCATALOG 
    DBCCCHECKIDENT 
    DBCCCHECKCONSTRAINTS 
    Summary 
    Index
  • 内容简介:
      《深入解析SQLServer2008(英文版)》是讲述SQLServer关系数据库引擎内部机理和架构的权威指南。书中详细阐述了SQLServer处理查询、管理数据的相关内容,包括SQLServer架构和配置、跟踪/扩展事件、日志和恢复、索引、表格、查询优化、事务/并发以及DBCC。
      《深入解析SQLServer2008(英文版)》适合中高级数据库开发人员阅读。
  • 作者简介:
      KalenDelanay世界知名的SQLServer专家。微软SQLSewerMVP。从1987年供职Sybase时与微软合作开发最早的SQLServer版本算起。她的SQLSewer研发经验已达20多年。她本人以对SQLServer底层技术的精湛造诣享誉业内。所著InsideMicrosoftSQLServer系列(本书前身)长期以来被奉为圣经级著作。
      PaulS.Randal和KJmberlyL.Tripp夫妇世界知名的SQLServer专家。微软SQLSewerMVP。他们都曾长期效力于微软SQLSewer开发团队。Randal更是在SQLSewer多个版本中负责存储引擎的开发。
      ConorCunningham目前担任SQLSewerver引擎主架构师。负责下一代引擎的设计和开发。AdamMachanic世界知名的SQLServer专家。微软SQLServerMVP。著名社区SQLblog.com创始人。名著《SQLSewer2005编程艺术》的作者。
      BenNevarez资深D8A。有多年SQLSewer管理经验。
  • 目录:
    1 SQLServer2008ArchitectureandConfiguration 
    SQLServerEditions
    SQLServerMetadata 
    CompatibilityViews 
    CatalogViews 
    OtherMetadata 
    ComponentsoftheSQLServerEngine
    ObservingEngineBehavior
    Protocols 
    TheRelationalEngine 
    TheStorageEngine 
    TheSQLOS
    NUMAArchitecture
    TheScheduler 
    SQLServerWorkers
    BindingSchedulerstoCPUs 
    TheDedicatedAdministratorConnection(DAC) 
    Memory 
    TheBufferPoolandtheDataCache 
    AccesstoIn-MemoryDataPages 
    ManagingPagesintheDataCache 
    TheFreeBufferListandtheLazywriter 
    Checkpoints 
    ManagingMemoryinOtherCaches 
    SizingMemory 
    SizingtheBufferPool 
    SQLServerResourceGovernor 
    ResourceGovernorOverview 
    ResourceGovernorControls 
    ResourceGovernorMetadata 
    SQLServer2008Configuration 
    UsingSQLServerConfigurationManager 
    ConfiguringNetworkProtocols 
    DefaultNetworkConfiguration 
    ManagingServices 
    SQLServerSystemConfiguration 
    OperatingSystemConfiguration 
    TraceFlags 
    SQLServerConfigurationSettings 
    TheDefaultTrace 
    FinalWords 
    2 ChangeTracking,Tracing,andExtendedEvents 
    TheBasics:TriggersandEventNotifications 
    Run-TimeTriggerBehavior 
    ChangeTracking 
    ChangeTrackingConfiguration 
    ChangeTrackingRun-TimeBehavior
    TracingandProfiling
    SQLTraceArchitectureandTerminology
    SecurityandPermissions
    GettingStarted:Profiler
    Server-SideTracingandCollection
    ExtendedEvents 
    ComponentsoftheXEInfrastructure 
    EventSessions 
    ExtendedEventsDDLandQuerying 
    Summary 
    3 DatabasesandDatabaseFiles 
    SystemDatabases 
    master 
    model 
    tempdb 
    TheResourceDatabase 
    msdb 
    SampleDatabases 
    AdventureWorks 
    pubs 
    Northwind 
    DatabaseFiles 
    CreatingaDatabase 
    ACREATEDATABASEExample 
    ExpandingorShrinkingaDatabase 
    AutomaticFileExpansion 
    ManualFileExpansion 
    FastFileInitialization 
    AutomaticShrinkage 
    ManualShrinkage 
    UsingDatabaseFilegroups 
    TheDefaultFilegroup 
    AFILEGROUPCREATIONExample 
    FilestreamFilegroups 
    AlteringaDatabase 
    ALTERDATABASEExamples 
    DatabasesUndertheHood 
    SpaceAllocation 
    SettingDatabaseOptions 
    StateOptions 
    CursorOptions 
    AutoOptions 
    SQLOptions 
    DatabaseRecoveryOptions 
    OtherDatabaseOptions 
    DatabaseSnapshots 
    CreatingaDatabaseSnapshot 
    SpaceUsedbyDatabaseSnapshots 
    ManagingYourSnapshots 
    ThetempdbDatabase 
    Objectsintempdb 
    Optimizationsintempdb 
    BestPractices 
    tempdbSpaceMonitoring 
    DatabaseSecurity 
    DatabaseAccess 
    ManagingDatabaseSecurity 
    Databasesvs.Schemas 
    PrincipalsandSchemas 
    DefaultSchemas 
    MovingorCopyingaDatabase 
    DetachingandReattachingaDatabase 
    BackingUpandRestoringaDatabase 
    MovingSystemDatabases 
    MovingthemasterDatabase 
    CompatibilityLevels 
    Summary
    4 LoggingandRecovery
    TransactionLogBasics
    PhasesofRecovery
    ReadingtheLog
    ChangesinLogSize
    VirtualLogFiles
    ObservingVirtualLogFiles
    AutomaticTruncationofVirtualLogFiles
    MaintainingaRecoverableLog
    AutomaticShrinkingoftheLog
    LogFileSize
    BackingUpandRestoringaDatabase
    TypesofBackups
    RecoveryModels
    ChoosingaBackupType 
    RestoringaDatabase 
    Summary 
    5 Tables 
    CreatingTables 
    NamingTablesandColumns 
    ReservedKeywords 
    DelimitedIdentifiers 
    NamingConventions 
    DataTypes 
    MuchAdoAboutNULL 
    User-DefinedDataTypes 
    IDENTITYProperty 
    InternalStorage 
    Thesys.indexesCatalogView 
    DataStorageMetadata 
    DataPages 
    ExaminingDataPages 
    TheStructureofDataRows 
    FindingaPhysicalPage 
    StorageofFixed-LengthRows 
    StorageofVariable-LengthRows 
    StorageofDateandTimeData 
    Storageofsql_variantData 
    Constraints 
    ConstraintNamesandCatalogViewInformation 
    ConstraintFailuresinTransactionsandMultiple-RowDataModifications 
    AlteringaTable 
    ChangingaDataType 
    AddingaNewColumn 
    Adding,Dropping,Disabling,orEnablingaConstraint 
    DroppingaColumn 
    EnablingorDisablingaTrigger 
    InternalsofAlteringTables 
    HeapModificationInternals 
    AllocationStructures 
    InsertingRows 
    DeletingRows 
    UpdatingRows 
    Summary 
    6 Indexes:InternalsandManagement 
    Overview 
    SQLServerIndexB-trees 
    ToolsforAnalyzingIndexes 
    Usingthedm_db_index_physical_statsDMV 
    UsingDBCCIND 
    UnderstandingIndexStructures 
    TheDependencyontheClusteringKey 
    NonclusteredIndexes 
    ConstraintsandIndexes 
    IndexCreationOptions 
    IGNORE_DUP_KEY 
    STATISTICS_NORECOMPUTE 
    MAXDOP 
    IndexPlacement 
    ConstraintsandIndexes 
    PhysicalIndexStructures 
    IndexRowFormats 
    ClusteredIndexStructures 
    TheNon-LeafLevel(s)ofaClusteredIndex 
    AnalyzingaClusteredIndexStructure 
    NonclusteredIndexStructures 
    SpecialIndexStructures 
    IndexesonComputedColumnsandIndexedViews 
    Full-TextIndexes 
    SpatialIndexes 
    XMLIndexes 
    DataModificationInternals 
    InsertingRows 
    SplittingPages 
    DeletingRows 
    UpdatingRows 
    Table-Levelvs Index-LevelDataModification 
    Logging 
    Locking 
    Fragmentation 
    ManagingIndexStructures 
    DroppingIndexes 
    ALTERINDEX 
    DetectingFragmentation 
    RemovingFragmentation 
    RebuildinganIndex 
    Summary 
    7 SpecialStorage 
    LargeObjectStorage 
    Restricted-LengthLargeObjectData(Row-OverflowData) 
    Unrestricted-LengthLargeObjectData 
    StorageofMAX-LengthData 
    FilestreamData 
    EnablingFilestreamDataforSQLServer 
    CreatingaFilestream-EnabledDatabase 
    CreatingaTabletoHoldFilestreamData 
    ManipulatingFilestreamData 
    MetadataforFilestreamData 
    PerformanceConsiderationsforFilestreamData 
    SparseColumns 
    ManagementofSparseColumns 
    ColumnSetsandSparseColumnManipulation 
    PhysicalStorage 
    Metadata 
    StorageSavingswithSparseColumns 
    DataCompression 
    Vardecimal 
    RowCompression 
    PageCompression 
    TableandIndexPartitioning 
    PartitionFunctionsandPartitionSchemes 
    MetadataforPartitioning 
    TheSlidingWindowBenefitsofPartitioning 
    Summary 
    8 TheQueryOptimizer 
    Overview 
    TreeFormat 
    WhatIsOptimization? 
    HowtheQueryOptimizerExploresQueryPlans 
    Rules 
    Properties 
    StorageofAlternatives—The“Memo” 
    Operators 
    OptimizerArchitecture 
    BeforeOptimization 
    Simplification 
    TrivialPlan/Auto-Parameterization 
    Limitations 
    TheMemo—ExploringMultiplePlansEfficiently 
    Statistics,CardinalityEstimation,andCosting 
    StatisticsDesign 
    Density/FrequencyInformation 
    FilteredStatistics 
    StringStatistics 
    CardinalityEstimationDetails 
    Limitations 
    Costing 
    IndexSelection 
    FilteredIndexes 
    IndexedViews 
    PartitionedTables 
    Partition-AlignedIndexViews 
    DataWarehousing 
    Updates 
    HalloweenProtection 
    Split/Sort/Collapse 
    Merge 
    WideUpdatePlans 
    SparseColumnUpdates 
    PartitionedUpdates 
    Locking 
    DistributedQuery 
    ExtendedIndexes 
    Full-TextIndexes 
    XMLIndexes 
    SpatialIndexes 
    PlanHinting 
    DebuggingPlanIssues 
    {HASH|ORDER}GROUP 
    {MERGE|HASH|CONCAT}UNION 
    FORCEORDER,{LOOP|MERGE|HASH}JOIN 
    INDEX=indexname|indexid 
    FORCESEEK 
    FASTnumber_rows 
    MAXDOPN 
    OPTIMIZEFOR 
    PARAMETERIZATION{SIMPLE|FORCED} 
    NOEXPAND 
    USEPLAN 
    Summary 
    9 PlanCachingandRecompilation 
    ThePlanCache 
    PlanCacheMetadata 
    ClearingPlanCache 
    CachingMechanisms 
    AdhocQueryCaching 
    OptimizingforAdhocWorkloads 
    SimpleParameterization 
    PreparedQueries 
    CompiledObjects 
    CausesofRecompilation 
    PlanCacheInternals 
    CacheStores 
    CompiledPlans 
    ExecutionContexts 
    PlanCacheMetadata 
    Handles 
    sys.dm_exec_sql_text 
    sys.dm_exec_query_plan 
    sys.dm_exec_text_query_plan 
    sys.dm_exec_cached_plans 
    sys.dm_exec_cached_plan_dependent_objects 
    sys.dm_exec_requests 
    sys.dm_exec_query_stats 
    CacheSizeManagement 
    CostingofCacheEntries 
    ObjectsinPlanCache:TheBigPicture 
    MultiplePlansinCache 
    WhentoUseStoredProceduresandOtherCachingMechanisms 
    TroubleshootingPlanCacheIssues 
    WaitStatisticsIndicatingPlanCacheProblems 
    OtherCachingIssues 
    HandlingProblemswithCompilationandRecompilation 
    PlanGuidesandOptimizationHints 
    Summary 
    10 TransactionsandConcurrency 
    ConcurrencyModels 
    PessimisticConcurrency 
    OptimisticConcurrency 
    TransactionProcessing 
    ACIDProperties 
    TransactionDependencies 
    IsolationLevels 
    Locking 
    LockingBasics 
    Spinlocks 
    LockTypesforUserData 
    LockModes 
    LockGranularity 
    LockDuration 
    LockOwnership 
    ViewingLocks 
    LockingExamples 
    LockCompatibility 
    InternalLockingArchitecture 
    LockPartitioning 
    LockBlocks 
    LockOwnerBlocks 
    syslockinfoTable 
    Row-LevelLockingvs Page-LevelLocking 
    LockEscalation 
    Deadlocks 
    RowVersioning 
    OverviewofRowVersioning 
    RowVersioningDetails 
    Snapshot-BasedIsolationLevels 
    ChoosingaConcurrencyModel 
    ControllingLocking 
    LockHints 
    Summary 
    11 DBCCInternals 
    GettingaConsistentViewoftheDatabase 
    ObtainingaConsistentView 
    ProcessingtheDatabaseEfficiently 
    FactGeneration 
    UsingtheQueryProcessor 
    Batches 
    ReadingthePagestoProcess 
    Parallelism 
    PrimitiveSystemCatalogConsistencyChecks 
    AllocationConsistencyChecks 
    CollectingAllocationFacts 
    CheckingAllocationFacts 
    Per-TableLogicalConsistencyChecks 
    MetadataConsistencyChecks 
    PageAudit 
    DataandIndexPageProcessing 
    ColumnProcessing 
    TextPageProcessing 
    Cross-PageConsistencyChecks 
    Cross-TableConsistencyChecks 
    ServiceBrokerConsistencyChecks 
    Cross-CatalogConsistencyChecks 
    Indexed-ViewConsistencyChecks 
    XML-IndexConsistencyChecks 
    Spatial-IndexConsistencyChecks 
    DBCCCHECKDBOutput 
    RegularOutput 
    SQLServerErrorLogOutput 
    ApplicationEventLogOutput 
    ProgressReportingOutput 
    DBCCCHECKDBOptions 
    NOINDEX 
    RepairOptions 
    ALL_ERRORMSGS 
    EXTENDED_LOGICAL_CHECKS 
    NO_INFOMSGS 
    TABLOCK 
    ESTIMATEONLY 
    PHYSICAL_ONLY 
    DATA_PURITY 
    DatabaseRepairs 
    RepairMechanisms 
    EmergencyModeRepair 
    WhatDataWasDeletedbyRepair? 
    Consistency-CheckingCommandsOtherThanDBCCCHECKDB 
    DBCCCHECKALLOC 
    DBCCCHECKTABLE 
    DBCCCHECKFILEGROUP 
    DBCCCHECKCATALOG 
    DBCCCHECKIDENT 
    DBCCCHECKCONSTRAINTS 
    Summary 
    Index
查看详情
其他版本 / 全部 (1)
系列丛书 / 更多
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
C#与.NET 3.5高级程序设计:第4版
特罗尔森(Andrew troelsen)、朱晔、肖逵、张大磊 著
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入解析Windows操作系统:微软官方Windows权威著作最新版
[美]拉西诺维奇 著
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
.NET设计规范:约定、惯用法与模式
[美]克瓦林纳、[美]艾布拉姆斯 著
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
WCF揭秘
[美]麦克默蒂 著;赵科平 译
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
ASP.NET电子商务开发实战
[罗马尼亚]戴瑞、[美]沃特森 著;徐锋、施游、陈绍继 译
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
ASP.NET 3.5 揭秘(卷2)
[美]沃尔瑟 著;谭振林 译
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
构建高性能可扩展ASP.NET网站
[美]Richard Kiessig 著;余昭辉 译
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
Visual Studio技术大全
[美]鲍尔、[美]斯内尔 著;刘彦博 译
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
.NET软件架构之美(英文版)
埃斯波西托(Dino Esposito)、索尔塔雷罗(Andrea Saltarello) 著
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入理解.NET:(第2版.英文影印版)
[美]里克特(Richter J.) 著
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
C#企业应用开发艺术:CSLA.NET 框架开发实战
[美]霍特卡 著;侯伯薇 译
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
More Effective C#:改善C#程序的50个具体办法(英文版)
[美]瓦格纳 著
相关图书 / 更多
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入理解移动互联网
吴功宜 吴英 编著
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入实施“四个育人”,彰显本科人才培养特色——云南大学本科教育改革与创新优秀论文集
主编唐旭光
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入浅出C语言程序设计(第3版·微课版)
李俊·c;强振平;荣剑;张晴晖;赵毅力;钟丽辉
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入浅出C#(视频教学版)
赵云
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入实践Kotlin元编程
霍丙乾 著
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入北方的小路(布克奖震撼杰作。人生在世,行走于地狱屋顶,凝望花朵。余华力荐“了不起的小说”!)
[澳]理查德·弗兰纳根 著;新经典 出品
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入学习习近平关于科技创新的重要论述
科学技术部编写组 著
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入浅出IoT:完整项目通关实战
[英]吉姆·贝内特(Jim Bennett) 著;柴火创客空间 译;[美]珍·福克斯(Jen Fox);[美]珍·卢珀(Jen Looper)
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入浅出SSD:固态存储核心技术、原理与实战 第2版
SSDFans 胡波 石亮 岑彪
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入地心 少儿科普 新华正版
英国尤斯伯恩出版公司
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入理解FFmpeg
刘歧 赵军 杜金房 赵文杰 宋韶颍
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
深入人心:数字产品设计的底层逻辑
林婕
您可能感兴趣 / 更多
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
宇宙视觉史:从宇宙大爆炸到时间的尽头
[美]查尔斯·刘 著;高爽 译者;[美]马克西姆· 马洛维奇科 绘;未读 出品
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
写出我心 普通人如何通过写作表达自己(平装本)
[美]娜塔莉·戈德堡(Natalie Goldberg)
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
写出我心3 写作疗愈的真正秘密
[美]娜塔莉·戈德堡(Natalie Goldberg)
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
神套路:为什么我们总被带节奏(狂热与网红时代醍醐灌顶之作,教给普通人安身立命的不二法门!)
[美]阿里·阿莫萨维 著;[哥伦比亚]亚历杭德罗·希拉尔多 绘
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
阿伦森自传
[美]埃利奥特·阿伦森(Elliot Aronson) 著;沈捷 译;湛庐文化 出品
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
街头官僚:公共服务中的个人困境
[美]迈克尔·李普斯基(Michael Lipsky)
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
史前至蒙古帝国时期的内欧亚大陆史
[美]大卫·克里斯蒂安 著;潘玲 译;杨建华 校
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
意大利文艺复兴新艺术史
[美]迈克尔·韦恩·科尔 著;[美]斯蒂芬·J·坎贝尔;邵亦杨
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
老人与海 彩图注音版 一二三四年级5-6-7-8-9岁小学生课外阅读经典 儿童文学无障碍有声伴读世界名著童话故事
[美]海明威
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
养育的觉醒:全面激发孩子自驱力,教你如何心平气和做妈妈
[美]凯文·莱曼 著;唐晓璐 译;斯坦威 出品
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
自律我也能做到(全9册)
[美]康妮·科维尔·米勒 著;[阿根廷]维多利亚·阿萨纳利 绘
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
你在等什么?
[美]斯科特·明钦 著;[中]易万 译;[美]马特 ·斐兰 绘