Pro SQL Server Internals (eBook)
XXV, 804 Seiten
Apress (Verlag)
978-1-4302-5963-3 (ISBN)
Pro SQL Server Internals explains how different SQL Server components work 'under the hood' and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems.
Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You'll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use.
Pro SQL Server Internals does the following:
- Explains how to design efficient database schema, indexing, and transaction strategies.
- Shows how various database objects and technologies are implemented internally and when they should or should not be used.
- Demonstrates how SQL Server executes queries and works with data and transaction logs.
Pro SQL Server Internals explains how different SQL Server components work "e;under the hood"e; and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems.Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You'll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use.Pro SQL Server Internals does the following:Explains how to design efficient database schema, indexing, and transaction strategies.Shows how various database objects and technologies are implemented internally and when they should or should not be used.Demonstrates how SQL Server executes queries and works with data and transaction logs.
Dmitri Korotkevitch is Microsoft SQL Server MVP and Microsoft Certified Master (in SQL Server 2008). He brings years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. He specializes in design, development, and performance tuning of OLTP Systems working under heavy load.Dmitri regularly speaks at various Microsoft and SQL PASS events, and he provides SQL Server training to clients around the world. He blogs at: http://aboutsqlserver.com.
Part 1 – Tables and Indexes• Chapter 1: Data storage internals• Chapter 2: Tables and Indexes – Internal Structure and Access Methods• Chapter 3: Statistics • Chapter 4: Special Indexing and Storage Features• Chapter 5: Index fragmentation• Chapter 6: Designing and tuning the indexes Part 2: Other things that matter• Chapter 7: Constraints• Chapter 8: Triggers• Chapter 9: Views • Chapter 10: Functions • Chapter 11: XML • Chapter 12: Temporary Tables • Chapter 13: CLR• Chapter 14: CLR types • Chapter 15: Data partitioning • Chapter 16: System design considerations Part 3: Locking, Blocking and Concurrency• Chapter 17: Lock types • Chapter 18: Troubleshooting Blocking issues• Chapter 19: Deadlocks • Chapter 20: Lock Escalations • Chapter 21: Optimistic isolation levels • Chapter 22: Application locks • Chapter 23: Schema locks • Chapter 24: Designing transaction strategies Part 4: Query Life Cycle • Chapter 25: Query Optimization and Execution• Chapter 26: Plan CachingPart 5: Practical Troubleshooting • Chapter 27: System Troubleshooting• Chapter 28: Extended eventsPart 6: Inside the transaction log • Chapter 29: Transaction Log Internals • Chapter 30: Designing a Backup Strategy • Chapter 31: Designing aHigh Availability StrategyPart 7: In-Memory OLTP Engine• Chapter 32: Hekaton (In Memory OLTP Engine)Part 8: Columnstore Indexes• Chapter 33: In-Memory OLTP Programmability• Chapter 34: Introduction to Columnstore indexes • Chapter 35: Clustered Columnstore indexes
| Erscheint lt. Verlag | 30.6.2014 |
|---|---|
| Zusatzinfo | XXV, 804 p. 437 illus. |
| Verlagsort | Berkeley |
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| ISBN-10 | 1-4302-5963-9 / 1430259639 |
| ISBN-13 | 978-1-4302-5963-3 / 9781430259633 |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)Größe: 44,7 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
