成功加入购物车
正版库存书,
[美] 德莱尼 著 / 人民邮电出版社 / 2009-09 / 平装
售价 ¥ 99.00
品相 九五品
优惠 满包邮
延迟发货说明
上书时间2023-03-03
卖家超过10天未登录
深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
《深入解析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 SQLServerEditionsSQLServerMetadata CompatibilityViews CatalogViews OtherMetadata ComponentsoftheSQLServerEngineObservingEngineBehaviorProtocols TheRelationalEngine TheStorageEngine TheSQLOSNUMAArchitectureTheScheduler SQLServerWorkersBindingSchedulerstoCPUs 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-TimeBehaviorTracingandProfilingSQLTraceArchitectureandTerminologySecurityandPermissionsGettingStarted:ProfilerServer-SideTracingandCollectionExtendedEvents 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 Summary4 LoggingandRecoveryTransactionLogBasicsPhasesofRecoveryReadingtheLogChangesinLogSizeVirtualLogFilesObservingVirtualLogFilesAutomaticTruncationofVirtualLogFilesMaintainingaRecoverableLogAutomaticShrinkingoftheLogLogFileSizeBackingUpandRestoringaDatabaseTypesofBackupsRecoveryModelsChoosingaBackupType 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
展开全部
配送说明
...
相似商品
为你推荐
开播时间:09月02日 10:30