Articoli correlati a Microsoft SQL Server 2008 Internals
Sinossi
Delve inside the core SQL Server engine and put that knowledge to work with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes and capture the product’s full potential.
Discover how SQL Server works behind the scenes, including:
- What happens internally when SQL Server builds, expands, shrinks, and moves databases
- How to use event tracking from triggers to the Extended Events Engine
- Why the right indexes can drastically reduce your query execution time
- How to transcend normal row-size limits with new storage capabilities
- How the Query Optimizer operates
- Multiple techniques for troubleshooting problematic query plans
- When to force SQL Server to reuse a cached query plan or create a new one
- What SQL Server checks internally when running DBCC
- How to choose among five isolation levels and two concurrency models when working with multiple concurrent users
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
L'autore
Kalen Delaney is a Microsoft MVP who has worked with SQL Server since 1987. She's a subject-matter expert on Microsoft's official SQL Server courses and previously wrote Inside SQL Server (Microsoft Press). She lives in the Pacific Northwest.
Paul Randal and wife Kimberly L. Tripp are two of the most-sought-after SQL Server speakers in the world. A Microsoft MVP and Regional Director, Paul is also contributing editor to TechNet Magazine.
Kimberly L. Tripp is a SQL Server MVP and a Microsoft Regional Director and has worked with SQL Server since 1990. She lectures for a variety of events including Microsoft Tech*Ed and is married to co-editor and SQL guru Paul Randal.
Conor Cunningham is principal architect of the SQL Server Core Engine Team at Microsoft.
Contenuti
ForewordIntroductionChapter 1: SQL Server 2008 Architecture and ConfigurationChapter 2: Change Tracking, Tracing, and Extended EventsChapter 3: Databases and Database FilesChapter 4: Logging and RecoveryChapter 5: TablesChapter 6: Indexes: Internals and ManagementChapter 7: Special StorageChapter 8: The Query OptimizerChapter 9: Plan Caching and RecompilationChapter 10: Transactions and ConcurrencyChapter 11: DBCC InternalsAppendix : About the Authors
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
- EditoreMicrosoft Pr
- Data di pubblicazione2009
- ISBN 10 0735626243
- ISBN 13 9780735626249
- RilegaturaCopertina flessibile
- LinguaInglese
- Numero edizione1
- Numero di pagine754
Compra nuovo
Visualizza questo articolo
EUR 31,71
EUR 3,80 per la spedizione in U.S.A.
Destinazione, tempi e costiAltre edizioni note dello stesso titolo
Risultati della ricerca per Microsoft SQL Server 2008 Internals
Foto dell'editore
Microsoft® SQL Server® 2008 Internals
Editore:
Pearson Education, 2009
ISBN 10: 0735626243
ISBN 13: 9780735626249
Antico o usato
Brossura
Prima edizione
Da: Better World Books: West, Reno, NV, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: Good. 1st Edition. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Codice articolo 5626956-6
Quantità: 2 disponibili
Foto dell'editore
Microsoft(r) SQL Server(r) 2008 Internals
Da: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: Fair. No Jacket. Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less 3.4. Codice articolo G0735626243I5N00
Quantità: 1 disponibili
Foto dell'editore
Microsoft? SQL Server? 2008 Internals
Da: TextbookRush, Grandview Heights, OH, U.S.A.
Valutazione del venditore 4 su 5 stelle
Condizione: Good. Expedited orders RECEIVED in 1-5 business days within the United States. Orders ship SAME or NEXT business day. We proudly ship to APO/FPO addresses. 100% Satisfaction Guaranteed! Codice articolo 45667920
Quantità: 1 disponibili
Foto dell'editore
Microsoft® SQL Server® 2008 Internals
Editore:
Pearson Education, 2009
ISBN 10: 0735626243
ISBN 13: 9780735626249
Antico o usato
Brossura
Prima edizione
Da: Better World Books Ltd, Dunfermline, Regno Unito
Valutazione del venditore 5 su 5 stelle
Condizione: Very Good. 1st Edition. Ships from the UK. Former library book; may include library markings. Used book that is in excellent condition. May show signs of wear or have minor defects. Codice articolo GRP102741460
Quantità: 1 disponibili
Foto dell'editore
Microsoft® SQL Server® 2008 Internals
Editore:
Pearson Education, 2009
ISBN 10: 0735626243
ISBN 13: 9780735626249
Antico o usato
Brossura
Prima edizione
Da: Better World Books Ltd, Dunfermline, Regno Unito
Valutazione del venditore 5 su 5 stelle
Condizione: Good. 1st Edition. Ships from the UK. Used book that is in clean, average condition without any missing pages. Codice articolo 4595150-6
Quantità: 1 disponibili
Foto dell'editore
Microsoft® SQL Server® 2008 Internals (Pro - Developer)
Da: HPB-Emerald, Dallas, TX, U.S.A.
Valutazione del venditore 5 su 5 stelle
paperback. Condizione: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Codice articolo S_429995507
Quantità: 1 disponibili
Foto dell'editore
Microsoft® SQL Server® 2008 Internals (Pro - Developer)
Da: Toscana Books, AUSTIN, TX, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: new. Excellent Condition.Excels in customer satisfaction, prompt replies, and quality checks. Codice articolo Scanned0735626243
Quantità: 1 disponibili
Foto dell'editore
Microsoft Sql Server 2008 Internals
Da: Revaluation Books, Exeter, Regno Unito
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: Brand New. 1st edition. 784 pages. 9.25x7.50x2.00 inches. In Stock. Codice articolo 0735626243
Quantità: 1 disponibili