TY - BOOK ID - 695369 TI - Pro SQL Server Internals PY - 2014 SN - 1430259639 1430259620 1322131848 PB - Berkeley, CA : Apress : Imprint: Apress, DB - UniCat KW - Database management. KW - Client/server computing. KW - SQL server. KW - Data base management KW - Data services (Database management) KW - Database management services KW - DBMS (Computer science) KW - Generalized data management systems KW - Services, Database management KW - Systems, Database management KW - Systems, Generalized database management KW - Electronic data processing KW - Microsoft SQL server KW - Computing, Client/server KW - Distributed processing KW - Database Management. KW - Microsoft SQL server 2002 UR - https://www.unicat.be/uniCat?func=search&query=sysid:695369 AB - 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. ER -