深入解析SQL Server 2008(英文影印版)(微软SQL Server开发团队必读之作)
基本信息
- 作者: (美)Kalen Delaney Paul S.Randal Kimberly L.Tripp Conor Cunningham Adam Machanic Ben Nevarez [作译者介绍]
- 丛书名: 图灵程序设计丛书 数据库
- 出版社:人民邮电出版社
- ISBN:9787115211439
- 上架时间:2009-9-11
- 出版日期:2009 年9月
- 开本:16开
- 页码:754
- 版次:1-1
- 所属分类:
计算机 > 数据库 > SQL Server
编辑推荐
让Jim Gray和David Campbell拍案叫绝的圣经级著作.
微软SQL Server开发团队必读之作..
六位SQL Server专家巨献
深入剖析SQL Server 2008技术内幕...
推荐阅读
内容简介回到顶部↑
本书是讲述sql server关系数据库引擎内部机理和架构的权威指南。书中详细阐述了sql server处理查询、管理数据的相关内容,包括sql server架构和配置、跟踪/扩展事件、日志和恢复、索引、表格、查询优化、事务/并发以及dbcc。.
本书适合中高级数据库开发人员阅读。..
由kalen delaney编写的微软sql server图书一直是同类图书中的佼佼者,是sql server 开发人员、架构师和dba的案头必备书。如今,这本新书纳入微软阵容空前的“深入解析”(internals)系列,增加5位sql server顶级专家,深入剖析了sql server 2008的底层机理及其对应用程序的影响,更具权威性。...
本书适合中高级数据库开发人员阅读。..
由kalen delaney编写的微软sql server图书一直是同类图书中的佼佼者,是sql server 开发人员、架构师和dba的案头必备书。如今,这本新书纳入微软阵容空前的“深入解析”(internals)系列,增加5位sql server顶级专家,深入剖析了sql server 2008的底层机理及其对应用程序的影响,更具权威性。...
作译者回到顶部↑
本书提供作译者介绍
Kalen Delaney,世界知名的SQL Server专家,微软SQL Server MVP。从1987年供职Sybase时与微软合作开发最早的SQL Server版本算起,她的SQL Server开发经验超过20多年。她本人以对SQL Server底层技术的精湛造诣享誉业内。所著Inside Microsoft SQL Server系列(本书前身)长期以来被奉为圣经级著作。.
Paul S. Randal和Kimberly L. Tripp夫妇,世界知名的SQL Server专家,微软SQL Server MVP。他们都曾长期效力于微软SQL Server开发团队。Randal更是在SQL Server多个版本中负责存储引擎的开发。.... << 查看详细
Paul S. Randal和Kimberly L. Tripp夫妇,世界知名的SQL Server专家,微软SQL Server MVP。他们都曾长期效力于微软SQL Server开发团队。Randal更是在SQL Server多个版本中负责存储引擎的开发。.... << 查看详细
目录回到顶部↑
forewordxix .
introductionxxi
1 sql server 2008 architecture and confi guration 1
sql server editions 1
sql server metadata 2
compatibility views. 3
catalog views 4
other metadata 6
components of the sql server engine 8
observing engine behavior 9
protocols 11
the relational engine 12
the storage engine 14
the sqlos. 18
numa architecture 19
the scheduler 20
sql server workers 21
binding schedulers to cpus 24
the dedicated administrator connection (dac) 27
memory 29
introductionxxi
1 sql server 2008 architecture and confi guration 1
sql server editions 1
sql server metadata 2
compatibility views. 3
catalog views 4
other metadata 6
components of the sql server engine 8
observing engine behavior 9
protocols 11
the relational engine 12
the storage engine 14
the sqlos. 18
numa architecture 19
the scheduler 20
sql server workers 21
binding schedulers to cpus 24
the dedicated administrator connection (dac) 27
memory 29
前言回到顶部↑
The book you are now holding is the evolutionary successor to the Inside SQL Server series, which included Inside SQL Server 6.5, Inside SQL Server 7, Inside SQL Server 2000, and Inside SQL Server 2005 (in four volumes). The Inside series was becoming too unfocused, and the name “Inside” had been usurped by other authors and even other publishers. I needed a title that was much more indicative of what this book is really about. .
SQL Server 2008 Internals tells you how SQL Server, Microsoft’s fl agship relational database product, works. Along with that, I explain how you can use the knowledge of how it works to help you get better performance from the product, but that is a side effect, not the goal.
There are dozens of other books on the market that describe tuning and best practices for SQL Server. This one helps you understand why certain tuning practices work the way they do, and it helps you determine your own best practices as you continue to work with SQL Server as a developer, data architect, or DBA.
Who This Book Is For
This book is intended to be read by anyone who wants a deeper understanding of what SQL Server does behind the scenes. The focus of this book is on the core SQL Server engine—in particular, the query processor and the storage engine. I expect that you have some experience with both the SQL Server engine and with the T-SQL language. You don’t have to be an expert in either, but it helps if you aspire to become an expert and would like to fi nd out all you can about what SQL Server is actually doing when you submit a query for execution.
This series doesn’t discuss client programming interfaces, heterogeneous queries, business intelligence, or replication. In fact, most of the high-availability features are not covered, but a few, such as mirroring, are mentioned at a high level when we discuss database property settings. I don’t drill into the details of some internal operations, such as security, because that’s such a big topic it deserves a whole volume of its own.
My hope is that you’ll look at the cup as half full instead of half empty and appreciate this book for what it does include. As for the topics that aren’t included, I hope you’ll fi nd the information you need in other sources.
xxii Introduction
What This Book Is About
SQL Server Internals provides detailed information on the way that SQL Server processes your queries and manages your data. It starts with an overview of the architecture of the SQL Server relational database system and then continues looking at aspects of query processing and data storage in 10 additional chapters, as follows:
■ Chapter 1 SQL Server 2008 Architecture and Confi guration
■ Chapter 2 Change Tracking, Tracing, and Extended Events
■ Chapter 3 Databases and Database Files
■ Chapter 4 Logging and Recovery
■ Chapter 5 Tables
■ Chapter 6 Indexes: Internals and Management
■ Chapter 7 Special Storage
■ Chapter 8 The Query Optimizer
■ Chapter 9 Plan Caching and Recompilation
■ Chapter 10 Transactions and Concurrency
SQL Server 2008 Internals tells you how SQL Server, Microsoft’s fl agship relational database product, works. Along with that, I explain how you can use the knowledge of how it works to help you get better performance from the product, but that is a side effect, not the goal.
There are dozens of other books on the market that describe tuning and best practices for SQL Server. This one helps you understand why certain tuning practices work the way they do, and it helps you determine your own best practices as you continue to work with SQL Server as a developer, data architect, or DBA.
Who This Book Is For
This book is intended to be read by anyone who wants a deeper understanding of what SQL Server does behind the scenes. The focus of this book is on the core SQL Server engine—in particular, the query processor and the storage engine. I expect that you have some experience with both the SQL Server engine and with the T-SQL language. You don’t have to be an expert in either, but it helps if you aspire to become an expert and would like to fi nd out all you can about what SQL Server is actually doing when you submit a query for execution.
This series doesn’t discuss client programming interfaces, heterogeneous queries, business intelligence, or replication. In fact, most of the high-availability features are not covered, but a few, such as mirroring, are mentioned at a high level when we discuss database property settings. I don’t drill into the details of some internal operations, such as security, because that’s such a big topic it deserves a whole volume of its own.
My hope is that you’ll look at the cup as half full instead of half empty and appreciate this book for what it does include. As for the topics that aren’t included, I hope you’ll fi nd the information you need in other sources.
xxii Introduction
What This Book Is About
SQL Server Internals provides detailed information on the way that SQL Server processes your queries and manages your data. It starts with an overview of the architecture of the SQL Server relational database system and then continues looking at aspects of query processing and data storage in 10 additional chapters, as follows:
■ Chapter 1 SQL Server 2008 Architecture and Confi guration
■ Chapter 2 Change Tracking, Tracing, and Extended Events
■ Chapter 3 Databases and Database Files
■ Chapter 4 Logging and Recovery
■ Chapter 5 Tables
■ Chapter 6 Indexes: Internals and Management
■ Chapter 7 Special Storage
■ Chapter 8 The Query Optimizer
■ Chapter 9 Plan Caching and Recompilation
■ Chapter 10 Transactions and Concurrency
序言回到顶部↑
The developers who create products such as Microsoft SQL Server typically become experts in one area of the technology, such as access methods or query execution. They live and experience the product inside out and often know their component so deeply they acquire a “curse of knowledge”: they possess so much detail about their particular domain, they fi nd it diffi cult to describe their work in a way that helps customers get the most out of the product. Technical writers who create product-focused books, on the other hand, experience a product outside in. Most of these authors acquire a broad, but somewhat shallow, surface knowledge of the products they write about and produce valuable books, usually fi lled with many screenshots, which help new and intermediate users quickly learn how to get things done with the product. .
When the curse of knowledge meets surface knowledge, it leaves a gap where many of the great capabilities created by product developers don’t get communicated in a way that allows customers, particularly intermediate to advanced users, to use a product to its full potential. This is where Microsoft SQL Server 2008 Internals comes in. This book, like those in the earlier “Inside SQL Server” series, is the defi nitive reference for how SQL Server really works. Kalen Delaney has been working with the SQL Server product team for over a decade, spending countless hours with developers breaking through the curse of knowledge and then capturing the result in an incredibly clear form that allows intermediate to advanced users to wring the most from the capabilities of SQL Server. In Microsoft SQL Server 2008 Internals, Kalen is joined by four SQL Server experts who also share the gift of breaking the curse. Conor Cunningham and Paul Randal have years of experience as SQL Server product developers, and each of them is both a deep technical expert and a gifted communicator. Kimberly Tripp and Adam Machanic both combine a passion to really understand how things work and to then effectively share it with others. Kimberly and Adam are both standing-room-only speakers at SQL Server events. This team has captured and incorporated the details of key architectural changes for SQL Server 2008, resulting in a new, comprehensive internals reference for SQL Server. ..
There is a litmus test you can use to determine if a technical product title deserves a “ defi nitive reference” classifi cation. It’s a relatively easy test but a hard one for everybody to conduct. The test, quite simply, is to look at how many of the developers who created the product in question have a copy of the book on their shelves—and reference it. I can assure you that each version of Inside Microsoft SQL Server that Kalen has produced has met this test. Microsoft SQL Server 2008 Internals will, too. ...
Dave Campbell
Technical Fellow
Microsoft SQL Server
When the curse of knowledge meets surface knowledge, it leaves a gap where many of the great capabilities created by product developers don’t get communicated in a way that allows customers, particularly intermediate to advanced users, to use a product to its full potential. This is where Microsoft SQL Server 2008 Internals comes in. This book, like those in the earlier “Inside SQL Server” series, is the defi nitive reference for how SQL Server really works. Kalen Delaney has been working with the SQL Server product team for over a decade, spending countless hours with developers breaking through the curse of knowledge and then capturing the result in an incredibly clear form that allows intermediate to advanced users to wring the most from the capabilities of SQL Server. In Microsoft SQL Server 2008 Internals, Kalen is joined by four SQL Server experts who also share the gift of breaking the curse. Conor Cunningham and Paul Randal have years of experience as SQL Server product developers, and each of them is both a deep technical expert and a gifted communicator. Kimberly Tripp and Adam Machanic both combine a passion to really understand how things work and to then effectively share it with others. Kimberly and Adam are both standing-room-only speakers at SQL Server events. This team has captured and incorporated the details of key architectural changes for SQL Server 2008, resulting in a new, comprehensive internals reference for SQL Server. ..
There is a litmus test you can use to determine if a technical product title deserves a “ defi nitive reference” classifi cation. It’s a relatively easy test but a hard one for everybody to conduct. The test, quite simply, is to look at how many of the developers who created the product in question have a copy of the book on their shelves—and reference it. I can assure you that each version of Inside Microsoft SQL Server that Kalen has produced has met this test. Microsoft SQL Server 2008 Internals will, too. ...
Dave Campbell
Technical Fellow
Microsoft SQL Server
媒体评论回到顶部↑
“Kalen Delaney的书是我的案头必备之作……从中我学到了许多东西,我将不断重读,加深自己的理解。”.
——Jim Gray,已故图灵奖得主,数据库技术大师
“本书是剖析SQL Server底层工作原理的权威之作,值得每一位微软SQL Server开发团队的成员研读。”
——David Campbell,微软技术院士,SQL Server核心引擎主架构师...
——Jim Gray,已故图灵奖得主,数据库技术大师
“本书是剖析SQL Server底层工作原理的权威之作,值得每一位微软SQL Server开发团队的成员研读。”
——David Campbell,微软技术院士,SQL Server核心引擎主架构师...







点击看大图






加载中...

