Microsoft SQL Server 2012 Internals.pdf

(18303 KB) Pobierz
Microsoft SQL Server
2012 Internals
Kalen Delaney
Bob Beauchemin
Conor Cunningham
Jonathan Kehayias
Benjamin Nevarez
Paul S. Randal
Published with the authorization of Microsoft Corporation by:
O’Reilly Media, Inc.
1005 Gravenstein Highway North
Sebastopol, California 95472
Copyright © 2013 by Kalen Delaney
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any
means without the written permission of the publisher.
ISBN: 978-0-7356-5856-1
1 2 3 4 5 6 7 8 9 LSI 8 7 6 5 4 3
Printed and bound in the United States of America.
Microsoft Press books are available through booksellers and distributors worldwide. If you need support related
to this book, email Microsoft Press Book Support at
mspinput@microsoft.com.
Please tell us what you think of
this book at
http://www.microsoft.com/learning/booksurvey.
Microsoft and the trademarks listed at
http://www.microsoft.com/about/legal/en/us/IntellectualProperty/
Trademarks/EN-US.aspx
are trademarks of the Microsoft group of companies. All other marks are property of
their respective owners.
The example companies, organizations, products, domain names, email addresses, logos, people, places, and
events depicted herein are fictitious. No association with any real company, organization, product, domain name,
email address, logo, person, place, or event is intended or should be inferred.
This book expresses the author’s views and opinions. The information contained in this book is provided without
any express, statutory, or implied warranties. Neither the authors, O’Reilly Media, Inc., Microsoft Corporation,
nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly
or indirectly by this book.
Acquisitions and Developmental Editor:
Michael Bolinger
Production Editor:
Kara Ebrahim
Editorial Production:
Box 12 Communications
Technical Reviewers:
Benjamin Nevarez and Jonathan Kehayias
Copyeditor:
Box 12 Communications
Indexer:
Box 12 Communications
Cover Design:
Twist Creative • Seattle
Cover Composition:
Karen Montgomery
Illustrator:
Rebecca Demarest
Contents at a glance
Introduction
ChaPteR 1
ChaPteR 2
ChaPteR 3
ChaPteR 4
ChaPteR 5
ChaPteR 6
ChaPteR 7
ChaPteR 8
Chapter 9
ChaPteR 10
ChaPteR 11
ChaPteR 12
ChaPteR 13
ChaPteR 14
xix
1
35
99
139
171
203
297
381
457
513
611
703
765
837
SQL Server 2012 architecture and configuration
the SQLOS
Databases and database files
Special databases
Logging and recovery
table storage
Indexes: internals and management
Special storage
Special indexes
Query execution
the Query Optimizer
Plan caching and recompilation
transactions and concurrency
DBCC internals
Index
903

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin