Artículos relacionados a Microsoft® SQL Server® 2008 Internals

9780735626249: Microsoft® SQL Server® 2008 Internals
Tapa blanda
ISBN 10: 0735626243 ISBN 13: 9780735626249
Editorial: Microsoft Press, 2009

Sinopsis

Delve inside the core SQL Server engine―and put that knowledge to work―with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes―and capture the product’s full potential. Discover how SQL Server works behind the scenes, including:

  • What happens internally when SQL Server builds, expands, shrinks, and moves databases
  • How to use event tracking―from triggers to the Extended Events Engine
  • Why the right indexes can drastically reduce your query execution time
  • How to transcend normal row-size limits with new storage capabilities
  • How the Query Optimizer operates
  • Multiple techniques for troubleshooting problematic query plans
  • When to force SQL Server to reuse a cached query plan―or create a new one
  • What SQL Server checks internally when running DBCC
  • How to choose among five isolation levels and two concurrency models when working with multiple concurrent users

"Sinopsis" puede pertenecer a otra edición de este libro.

Acerca del autor

Conor Cunningham is principal architect of the SQL Server Core Engine Team at Microsoft.

"Sobre este título" puede pertenecer a otra edición de este libro.

Editorial
Microsoft Press
Año de publicación
2009
Idioma
Inglés
ISBN 10 
0735626243
ISBN 13 
9780735626249
Encuadernación
Tapa blanda
Número de páginas
752
Contacto del fabricante
no disponible
Persona responsable
no disponible