Microsoft SQL Server 2012 Internals

Valutazione media 4,31
( su 77 valutazioni fornite da GoodReads )
 
9780735658561: Microsoft SQL Server 2012 Internals

Dive deep inside the architecture of SQL Server 2012

Explore the core engine of Microsoft SQL Server 2012-and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases-whether you’re a database developer, architect, or administrator.

Discover how to:

  • Dig into SQL Server 2012 architecture and configuration
  • Use the right recovery model and control transaction logging
  • Reduce query execution time through proper index design
  • Track events, from triggers to the Extended Event Engine
  • Examine internal structures with database console commands
  • Transcend row-size limitations with special storage capabilities
  • Choose the right transaction isolation level and concurrency model
  • Take control over query plan caching and reuse

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

L'autore:

Kalen Delaney, a Microsoft MVP for SQL Server since 1993, provides advanced SQL Server training to clients worldwide. She is a contributing editor and columnist for SQL Server Magazine and the author of several highly regarded books, including Microsoft SQL Server 2008 Internals.

Conor Cunningham is principal architect of the SQL Server Core Engine Team at Microsoft.

Paul S. Randal is a Microsoft MVP, trainer, and contributing editor for TechNet Magazine.

Contenuti:

Introduction; Who should read this book; Organization of this book; Companion content; System requirements; Acknowledgments; Errata & book support; We want to hear from you; Stay in touch; Chapter 1: SQL Server 2012 architecture and configuration; 1.1 SQL Server editions; 1.2 SQL Server installation and tools; 1.3 SQL Server metadata; 1.4 Components of the SQL Server engine; 1.5 ; 1.6 SQL Server 2012 configuration; 1.7 SQL Server system configuration; 1.8 Conclusion; Chapter 2: The SQLOS; 2.1 NUMA architecture; 2.2 The scheduler; 2.3 Memory; 2.4 SQL Server Resource Governor; 2.5 Extended Events; 2.6 Conclusion; Chapter 3: Databases and database files; 3.1 Working with sample databases; 3.2 Understanding database files; 3.3 Expanding or shrinking a database; 3.4 Using database filegroups; 3.5 Altering a database; 3.6 Setting database options; 3.7 Understanding database security; 3.8 Moving or copying a database; 3.9 Understanding compatibility levels; 3.10 Conclusion; Chapter 4: Special databases; 4.1 System databases; 4.2 The tempdb database; 4.3 Database snapshots; 4.4 Partially contained databases; 4.5 Conclusion; Chapter 5: Logging and recovery; 5.1 Transaction log internals; 5.2 Changes in log size; 5.3 Database backup and restore; 5.4 Conclusion; Chapter 6: Table storage; 6.1 Table creation; 6.2 IDENTITY property; 6.3 Sequence object; 6.4 Internal storage; 6.5 Constraints; 6.6 Altering a table; 6.7 Heap modification internals; 6.8 Conclusion; Chapter 7: Indexes: internals and management; 7.1 Overview; 7.2 SQL Server B-tree indexes; 7.3 Tools for analyzing indexes; 7.4 Understanding B-tree index structures; 7.5 Index creation options; 7.6 Physical index structures for B-trees; 7.7 Indexes on computed columns and indexed views; 7.8 Data modification internals; 7.9 Managing B-tree index structures; 7.10 Columnstore indexes; 7.11 Conclusion; Chapter 8: Special storage; 8.1 Large object storage; 8.2 FILESTREAM and FileTable data; 8.3 Sparse columns; 8.4 Data compression; 8.5 Table and index partitioning; 8.6 Conclusion; Chapter 9: Special indexes; 9.1 Special indexes vs. ordinary indexes; 9.2 XML indexes; 9.3 Spatial indexes; 9.4 Full-text indexes; 9.5 Semantic indexes; 9.6 Conclusion; Chapter 10: Query execution; 10.1 Introducing query processing and execution; 10.2 Reading query plans; 10.3 Analyzing plans; 10.4 Understanding data warehouses; 10.5 Using columnstore indexes and batch processing; 10.6 Conclusion; Chapter 11: The Query Optimizer; 11.1 Overview; 11.2 Search space and heuristics; 11.3 Optimizer architecture; 11.4 Statistics, cardinality estimation, and costing; 11.5 Index selection; 11.6 Partitioned tables; 11.7 Windowing functions; 11.8 Data warehousing; 11.9 Updates; 11.10 Distributed query; 11.11 Extended indexes; 11.12 Plan hinting; 11.13 Hotfixes; 11.14 Conclusion; Chapter 12: Plan caching and recompilation; 12.1 The plan cache; 12.2 Caching mechanisms; 12.3 Plan cache internals; 12.4 Objects in plan cache: the big picture; 12.5 Optimization hints and plan guides; 12.6 Conclusion; Chapter 13: Transactions and concurrency; 13.1 Concurrency models; 13.2 Transaction processing; 13.3 Locking; 13.4 Row versioning; 13.5 Controlling locking; 13.6 Conclusion; Chapter 14: DBCC internals; 14.1 Shrinking files and databases; 14.2 Consistency checking; 14.3 Conclusion; About the authors;

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

Edizione Internazionale
Edizione Internazionale

1.

Kalen Delaney
ISBN 10: 0735658560 ISBN 13: 9780735658561
Nuovi Paperback Quantità: 1
Edizione Internazionale
Da
Bookstore99
(Wilmington, DE, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. This is an International Edition, Brand NEW, Shrink Wrapped, Paperback, Ships from multiple locations across the globe in 4-7 business days; delivered well within delivery estimates with Tracking. Choose Expedited Shipping for 3-4 Business DAY DELIVERY. ISBN and Cover page may differ. International edition does not comes with CD/access code. Book cover may contain restrictions but it is absolutely legal to use, may be printed in black & white having similar contents as US edition. Best Customer Support. Please READ Description Carefully Before Buying. Occasionally, international textbooks may come with different exercises at the end of chapters. Codice libro della libreria US_9789351192534

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 15,27
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 2,75
In U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

2.

Kalen Delaney
Editore: Wiley (2013)
ISBN 10: 0735658560 ISBN 13: 9780735658561
Nuovi Soft cover Quantità: > 20
Edizione Internazionale
Da
Books in my Basket
(New Delhi, India)
Valutazione libreria
[?]

Descrizione libro Wiley, 2013. Soft cover. Condizione libro: New. International Edition. 980pp. Book cover and ISBN different from US edition. Territorial Restrictions maybe printed on the book. This is an international edition. Codice libro della libreria 327663

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 14,30
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 4,10
Da: India a: U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

3.

Kalen Delaney
ISBN 10: 0735658560 ISBN 13: 9780735658561
Nuovi Softcover Prima edizione Quantità: > 20
Edizione Internazionale
Da
GREAT BOOKS DEAL
(TALLAHASSEE, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Softcover. Condizione libro: New. 1st edition. Brand New; Paperback; Black & White or Color International Edition. ISBN and Cover page may differ but similar contents as US edition. GET IT FAST in 3-5 business days by DHL/FEDEX with tracking number. Books printed in English. No shipping to PO Box/APO/FPO address. In some instances, the international textbooks may have different end chapter case studies and exercises. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" and "Content may different from U.S. Edition" - printed only to discourage U.S. students from obtaining an affordable copy. The U.S. Supreme Court has asserted your right to purchase international editions, and ruled on this issue. Access code or CD is not provided with these editions, unless specified. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. Customer satisfaction guaranteed. Codice libro della libreria INAB1500344

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 18,02
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,64
In U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

4.

Delaney, Kalen; Beauchemin, Bob; Cunningham, Conor; Kehayias, Jonathan; Randal, Paul S.; Nevarez, Benjamin
Editore: Microsoft Press
ISBN 10: 0735658560 ISBN 13: 9780735658561
Nuovi PAPERBACK Quantità: 5
Edizione Internazionale
Da
Ben's Book Shop
(Wilmington, DE, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Microsoft Press. PAPERBACK. Condizione libro: New. 0735658560 International Edition Paperback OR Softcover Edition with Same Contents. Fast Delivery. Book Cover and ISBN may be different from the US Edition. Customer satisfaction guaranteed. Codice libro della libreria INDMRK-9789351192534

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 18,28
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,67
In U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

5.

KALEN DELANEY
ISBN 10: 0735658560 ISBN 13: 9780735658561
Nuovi Brossura Quantità: 5
Edizione Internazionale
Da
bookscollection
(Delhi, DELHI, India)
Valutazione libreria
[?]

Descrizione libro Condizione libro: Brand New. PAPERBACK,Book Condition New, Brand New, Softcover, International Edition. We Do not Ship APO FPO AND PO BOX. Cover Image & ISBN may be different from US edition but contents as US Edition. Printing in English language. Quick delivery by USPS/UPS/DHL/FEDEX/ARAMEX ,Customer satisfaction guaranteed. We may ship the books from Asian regions for inventory purpose. Codice libro della libreria ABESTTND6120

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 18,65
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,60
Da: India a: U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

6.

KALEN DELANEY
ISBN 10: 0735658560 ISBN 13: 9780735658561
Nuovi Brossura Quantità: 5
Edizione Internazionale
Da
bookscollection
(Delhi, DELHI, India)
Valutazione libreria
[?]

Descrizione libro Condizione libro: Brand New. PAPERBACK,Book Condition New, Brand New, Softcover, International Edition. We Do not Ship APO FPO AND PO BOX. Cover Image & ISBN may be different from US edition but contents as US Edition. Printing in English language. Quick delivery by USPS/UPS/DHL/FEDEX/ARAMEX ,Customer satisfaction guaranteed. We may ship the books from Asian regions for inventory purpose. Codice libro della libreria ABEDUPPP4473

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 18,65
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,60
Da: India a: U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

7.

Kalen Delaney
ISBN 10: 0735658560 ISBN 13: 9780735658561
Nuovi Paperback Quantità: > 20
Edizione Internazionale
Da
US_Superfast_Bookstore
(New Castle, DE, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. This is an International Edition Brand New Paperback Same Title Author and Edition as listed. ISBN and Cover design differs. Similar Contents as U.S Edition. Standard Delivery within 6-14 business days ACROSS THE GLOBE. We can ship to PO Box address in US. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" or "For sale in Asia only" or similar restrictions- printed only to discourage students from obtaining an affordable copy. US Court has asserted your right to buy and use International edition. Access code/CD may not provided with these editions. We may ship the books from multiple warehouses across the globe including Asia depending upon the availability of inventory. Printed in English. Customer satisfaction guaranteed. Codice libro della libreria US9780735658561

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 21,13
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 2,44
In U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

8.

Delaney, Kalen; Beauchemin, Bob; Cunningham, Conor; Kehayias, Jonathan; Randal, Paul S.; Nevarez, Benjamin
Editore: Microsoft Press
ISBN 10: 0735658560 ISBN 13: 9780735658561
Nuovi Brossura Quantità: 15
Edizione Internazionale
Da
Sunshine Book Store
(Wilmington, DE, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Microsoft Press. Condizione libro: New. 0735658560 This is an International Edition. Brand New, Paperback, Delivery within 6-14 business days, Similar Contents as U.S Edition, ISBN and Cover design may differ, printed in Black & White. Choose Expedited shipping for delivery within 3-8 business days. We do not ship to PO Box, APO , FPO Address. In some instances, subjects such as Management, Accounting, Finance may have different end chapter case studies and exercises. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" and "Content may different from U.S. Edition" - printed only to discourage U.S. students from obtaining an affordable copy. The U.S. Supreme Court has asserted your right to purchase international editions, and ruled on this issue. Access code/CD is not provided with these editions , unless specified. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. Customer satisfaction guaranteed. Codice libro della libreria NU9780735658561

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 23,64
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

9.

Kalen Delaney , Bob Beauchemin , Conor Cunningham , Jonathan Kehayias , Paul S. Randal , Benjamin Ne
ISBN 10: 0735658560 ISBN 13: 9780735658561
Nuovi Paperback Quantità: 5
Edizione Internazionale
Da
PRIORITY BOOKS
(springfield, VA, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. Softcover Book, Condition: New. 1st Edition. [Please Read Carefully Before Buying], This Is An International Edition. Printed In Black and White. 982 Pages, Book Cover And ISBN No May Be Different From US Edition. Restricted Sales Disclaimer Wordings Not For Sales In USA And Canada May Be Printed On The Cover Of The Book. Standard Shipping 7-14 Business Days. Expedited Shiping 4-8 Business Days. ***WE DO NOT ENTERTAIN BULK ORDERS.*** The Books May Be Ship From Overseas For Inventory Purpose. Codice libro della libreria 406341

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 23,76
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,67
In U.S.A.
Destinazione, tempi e costi

10.

Kalen Delaney , Bob Beauchemin , Conor Cunningham , Jonathan Kehayias , Paul S. Randal , Benjamin Ne
ISBN 10: 0735658560 ISBN 13: 9780735658561
Nuovi Paperback Quantità: 1
Edizione Internazionale
Da
Nick Book House
(fresno, CA, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. New Softcover International Edition, Printed in Black and White, Only USPS Media mail Shipping ONLY, Different ISBN, Same Content As US edition, Book Cover may be Different, in English Language. Codice libro della libreria 26587

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 24,76
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,67
In U.S.A.
Destinazione, tempi e costi

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro