Microsoft SQL Server 2012 internals

Dive deep inside the architecture of SQL Server 2012 Explore the core engine of Microsoft SQL Server 2012—and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal...

Descripción completa

Detalles Bibliográficos
Autor principal: Delaney, Kalen (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Sebastopol, California : O'Reilly Media [2013]
Edición:1st edition
Colección:Developer Reference
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629274706719
Tabla de Contenidos:
  • SQL server 2012 architecture and configuration
  • The SQLOS
  • Databases and database file
  • Special databases
  • Logging and recovery
  • Table storage
  • Indexes : internals and management
  • Special storage
  • Special indexes
  • Query execution
  • The query optimizer
  • Plan caching and recompilation
  • Transactions and concurrency
  • DBCC internals.