Pro SQL Server Internals

Pro SQL Server Internals, 9781430259626 (1430259620), Apress, 2014

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.

Comments

Amazing Books

Artificial Intelligence for Games, Second Edition

Morgan and Claypool Publishers, 2009

Creating robust artificial intelligence is one of the greatest challenges for game developers, yet the commercial success of a game is often dependent upon the quality of the AI. In this book, Ian Millington brings extensive professional experience to the problem of improving the quality of AI in games. He describes numerous examples from...

Spatial Data on the Web: Modeling and Management

Springer, 2007

Spatial data is essential in a wide range of application domains today. While geographical applications remain the key target area, spatial properties are required in other contexts such as computer-aided design, robotics and image processing. Associated with these is the constantly growing number of distributed processing architectures, based on,...

Types and Programming Languages

MIT Press, 2002

A type system is a syntactic method for automatically checking the absence of certain erroneous behaviors by classifying program phrases according to the kinds of values they compute. The study of type systems--and of programming languages from a type-theoretic perspective--has important applications in software engineering, language design,...

Oracle SQL*Plus Pocket Reference (Pocket Reference (O'Reilly))

O'Reilly, 2004

The Oracle SQLPlus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest...

LINQ for VB 2005

Apress, 2007

Are you ready for the future of data access in .NET?

At the Microsoft Professional Developers Conference (PDC) 2005, Microsoft previewed a new technology, Language-Integrated Query (LINQ). It captured a lot of attention because it addressed the fundamental issue of merging object-oriented applications with relational data. The LINQ...

Communication Systems for the Mobile Information Society

John Wiley & Sons, 2006

"Communication Systems for the Mobile Information Society" not only contains a technical description of the different wireless systems available today, but also explains the thoughts that are behind the different mechanisms and implementations; not only the 'how' but also the 'why' is in focus. Thus the advantages and...