Cover Image
Read Now

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 Serve...

Full description

Bibliographic Details
Main Author: Korotkevitch, Dmitri
Format: eBook
Language:English
Published: Berkeley, CA, New York, NY Apress, Distributed to the Book trade worldwide by Springer 2014
Series:The expert's voice in SQL server
Subjects:
Computers / Client-server Computing / Bisacsh
Databasebeheer
Client/server Computing / Http://id.loc.gov/authorities/subjects/sh93000502
Bases De Données / Gestion
Sql Server / Blmlsh
Information And Communication Technology (general)
Client/server Computing / Fast
Sql Server / Fast
Database Management
Database Management / Fast
Sql Server / Http://id.loc.gov/authorities/names/n90684343
Computerwetenschappen
Database Management / Http://id.loc.gov/authorities/subjects/sh85035848
Computers / Databases / General / Bisacsh
Computer Sciences
Informatie- En Communicatietechnologie (algemeen)
Computers / Programming Languages / Sql. / Bisacsh
Architecture Client-serveur (informatique)
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Description
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
Physical Description:xxv, 750 pages illustrations
ISBN:9781430259633
9781484219645
1430259639

Similar Items