Inside Microsoft SQL server 2005 : query tuning and optimization /

Dive deep into the internals of query tuning and optimization in SQL Server 2005 with this comprehensive reference. Understanding the internals of SQL Server helps database developers and administrators to better create, access, and effectively process information from enterprise data. Written by ex...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Delaney, Kalen
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Redmond, Wash. : Microsoft Press, 2007.
Temas:
SQL server.
Client/server computing.
Relational databases.
Architecture client-serveur (Informatique)
Bases de données relationnelles.
Databases
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 1. A Performance Troubleshooting Methodology
  • 2. Tracing and Profiling
  • 3. Query Execution
  • 4. Troubleshooting Query Performance
  • 5. Plan Caching and Recompilation
  • 6. Concurrency Problems.

Ejemplares similares