• Complain

Kalen Delaney - Microsoft SQL Server 2012 Internals

Here you can read online Kalen Delaney - Microsoft SQL Server 2012 Internals full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. City: Sebastopol;Calif, year: 2013, publisher: Microsoft Press;OReilly Media, genre: Romance novel. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

Kalen Delaney Microsoft SQL Server 2012 Internals

Microsoft SQL Server 2012 Internals: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "Microsoft SQL Server 2012 Internals" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

SQL server 2012 architecture and configuration -- The SQLOS -- Databases and database file -- 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.

Kalen Delaney: author's other books


Who wrote Microsoft SQL Server 2012 Internals? Find out the surname, the name of the author of the book and a list of all author's works by series.

Microsoft SQL Server 2012 Internals — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Microsoft SQL Server 2012 Internals" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

Make
Microsoft SQL Server 2012 Internals
Kalen Delaney
Bob Beauchemin
Conor Cunningham
Jonathan Kehayias
Benjamin Nevarez
Paul S. Randal
Published by Microsoft Press
Introduction

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) and the SQL Server 2008 Internals book. The name was changed for SQL Server 2008 because 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 2012 Internals tells you how SQL Server, Microsofts flagship 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 should read this book

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 enginein 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 dont have to be an expert in either, but it helps if you aspire to become an expert and would like to find out all you can about what SQL Server is actually doing when you submit a query for execution.

This series doesnt 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 dont drill into the details of some internal operations, such as security, because thats such a big topic it deserves a whole volume of its own.

My hope is that youll 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 arent included, I hope youll find the information you need in other sources.

Organization of this book

SQL Server 2012 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 13 additional chapters. The content from the SQL Server 2008 Internals book has been enhanced to cover changes and relevant new features of SQL Server 2012. In addition, it contains an entire chapter on the SQLOS, drawn from and enhanced from sections in the previous book, and a whole chapter on system databases, also drawn from and enhanced from content in the SQL Server 2008 book. There is also a brand new chapter on special indexes, including spatial indexes, XML indexes, fulltext indexes, and semantic indexes. Finally, the chapter on query execution from my Inside SQL Server 2005: Query Tuning and Optimization book has been include and updated for SQL Server 2012.

Companion content

This book features a companion website that makes available to you all the code used in the book, organized by chapter. The companion content also includes an extra chapter from my previous book, as well as the History of SQL Server chapter from my book Inside Microsoft SQL Server 2000 (Microsoft Press, 2000). The site also provides extra scripts and tools to enhance your experience and understanding of SQL Server internals. As errors are found and reported, they will also be posted online. You can access this content from the companion site at this address: http://www.SQLServerInternals.com/companion .

System requirements

To use the code samples, youll need Internet access and a system capable of running SQL Server 2012 Enterprise or Developer edition. To get system requirements for SQL Server 2012 and to obtain a trial version, go to http://www.microsoft.com/en-us/download/details.aspx?id=29066 .

Acknowledgments

As always, a work like this is not an individual effort, and for this current volume, it is truer than ever. I was honored to have five other SQL Server experts join me in writing SQL Server 2012 Internals , and I truly could not have written this book alone. I am grateful to Benjamin Nevarez, Paul Randal, Conor Cunningham, Jonathan Kehayias, and Bob Beauchemin for helping to make this book a reality. In addition to my brilliant co-authors, this book could never have seen the light of day without help and encouragement from many other people.

First on my list is you, the reader. Thank you to all of you for reading what I have written. Thank you to those who have taken the time to write to me about what you thought of the book and what else you want to learn about SQL Server. I wish I could answer every question in detail. I appreciate all your input, even when Im unable to send you a complete reply. One particular reader of one of my previous books, Inside Microsoft SQL Server 2005: The Storage Engine (Microsoft Press, 2006), deserves particular thanks. I came to know Ben Nevarez as a very astute reader who found some uncaught errors and subtle inconsistencies and politely and succinctly reported them to me through my website. Ben is now my most valued technical reviewer, and for this new edition, he is also an author!

As usual, the SQL Server team at Microsoft has been awesome. Although Lubor Kollar and Sunil Agarwal were not directly involved in much of the research for this book, I always knew they were there in spirit, and both of them always had an encouraging word whenever I saw them. Kevin Liu volunteered for the daunting task of coordinating my contracts with the SQL team, and always found me the right engineer to talk to when I had specific questions that needed to be answered.

Ryan Stonecipher, Kevin Farlee, Peter Byrne, Srini Acharya, and Susan Price met with me and responded to my (sometimes seemingly endless) emails. Fabricio Voznika, Peter Gvozdjak, Jeff East, Umachandar Jayachandran, Arkadi Brjazovski, Madhan Ramakrishnan, Cipri Clinciu, and Srikumar Rangarajan also offered valuable technical insights and information when responding to my emails. I hope they all know how much I appreciated every piece of information I received.

I am also indebted to Bob Ward, Bob Dorr, and Keith Elmore of the SQL Server Product Support team, not just for answering occasional questions but for making so much information about SQL Server available through white papers, conference presentations, and Knowledge Base articles. I am grateful to Alan Brewer and Gail Erickson for the great job they and their User Education team did putting together the SQL Server documentation in SQL Server Books Online .

I would like to extend my heartfelt thanks to all of the SQL Server MVPs, but most especially Erland Sommarskog. Erland wrote the section in on collations just because he thought it was needed, and that someone who has to deal with only the 26 letters of the English alphabet could never do it justice. Also deserving of special mention are Ben Miller, Tibor Karaszi, and John Paul Cook, for all the personal support and encouragement they gave me. Other MVPs who inspired me during the writing of this volume are Hugo Kornelis, Rob Farley, and Allen White. Being a part of the SQL Server MVP team continues to be one of the greatest honors and privileges of my professional life.

Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «Microsoft SQL Server 2012 Internals»

Look at similar books to Microsoft SQL Server 2012 Internals. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «Microsoft SQL Server 2012 Internals»

Discussion, reviews of the book Microsoft SQL Server 2012 Internals and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.