Pro SQL server internals
Explains how different SQL Server components work internally and how they communicate with each other. Presents a large number of examples that will show how various design and implementation decisions affect the behavior and performance of systems. Covers multiple SQL Server versions from SQL Server 2005 through SQL Server 2014. The book covers new SQL Server 2014 features including the new Cardinality Estimator. Topics covered include: designing efficient database schema, indexing, and transa…
Read More ↓Title Statements
- Full title :Pro SQL server internals / Dmitri Korotkevitch.
Summary
Explains how different SQL Server components work internally and how they communicate with each other. Presents a large number of examples that will show how various design and implementation decisions affect the behavior and performance of systems. Covers multiple SQL Server versions from SQL Server 2005 through SQL Server 2014. The book covers new SQL Server 2014 features including the new Cardinality Estimator. Topics covered include: designing efficient database schema, indexing, and transaction strategies and solutions utilizing SQL Server as the database backend; how various database objects and technologies are implemented internally and when they should or should not be used; how SQL Server executes queries and works with data and transaction logs; troubleshooting and addressing design, concurrency, and performance issues in systems; improving system availability and manageability and reduce implementation costs with data partitioning; designing efficient disaster recovery and high-availability strategies for systems; improving the performance of OLTP and data warehouse systems by utilizing new SQL Server 2014 features, such as the In-Memory OLTP Engine (codename Hekaton) and Clustered Columnstore Indexes. This book is for developers and database administrators.
Read More ↓Edition Statements
- Publication Date:©2014
Publication Statements
- Publisher(s):Apress
- Place of Publication:Berkeley, CA
- Language:eng
- Publication Date:©2014
The Physical Object
- Description:1 online resource (xxv, 750 pages) : : illustrations
Edition Identifiers
- ISBN:9781430259633, 1430259639, 9781484219645, 1484219643
- DOI:10.1007/978-1-4302-5963-3
- oclc:ocn883297697
- LC Classification:QA76.9.D3
- Dewey Decimal:005.75/85
Subjects
Writers
More from this Series
No reviews yet. Be the first to rate this work.
Related Works
more →
Principles of distributed systems: 7th international conference, OPODIS 20…
OPODIS (Conference), Martinique)
Rate & Review