深入解析SQL Server 2008:让Jim Gray和David Campbell拍案叫绝的圣经级著作
¥
39.2
4.0折
¥
99
九五品
仅1件
作者[美]德莱尼 著
出版社人民邮电出版社
出版时间2009-09
版次1
装帧平装
货号A4
上书时间2024-10-24
商品详情
- 品相描述:九五品
图书标准信息
-
作者
[美]德莱尼 著
-
出版社
人民邮电出版社
-
出版时间
2009-09
-
版次
1
-
ISBN
9787115211439
-
定价
99.00元
-
装帧
平装
-
开本
16开
-
纸张
胶版纸
-
页数
754页
-
字数
931千字
-
正文语种
英语
-
原版书名
Microsoft SQL Server 2008 Internals
-
丛书
图灵程序设计丛书·微软技术系列
- 【内容简介】
-
《深入解析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
点击展开
点击收起
— 没有更多了 —
以下为对购买帮助不大的评价