El Libro del Día: SQL Server 2012 Query Performance Tuning

El Libro del Día: 2014-12-12

Titulo: SQL Server 2012 Query Performance Tuning
Autor: Grant Fritchey
Editorial: Apress
Nro Paginas: 521

Capítulos:
Chapter 1: SQL Query Performance Tuning
Chapter 2: System Performance Analysis
Chapter 3: SQL Query Performance Analysis
Chapter 4: Index Analysis
Chapter 5: Database Engine Tuning Advisor
Chapter 6: Lookup Analysis
Chapter 7: Statistics Analysis
Chapter 8: Fragmentation Analysis
Chapter 9: Execution Plan Cache Analysis
Chapter 10: Query Recompilation
Chapter 11: Query Design Analysis
Chapter 12: Blocking Analysis
Chapter 13: Deadlock Analysis
Chapter 14: Cursor Cost Analysis
Chapter 15: Database Performance Testing
Chapter 16: Database Workload Optimization
Chapter 17: SQL Server Optimization Checklist

Descarga:
SQL_Server_2012_Query_Performance_Tuning

El Libro del Día: Expert Performance Indexing for SQL Server 2012

El Libro del Día: 2014-12-11

Titulo: Expert Performance Indexing for SQL Server 2012
Autor: Jason Strate, Ted Krueger
Editorial: Apress
Nro Paginas: 345

Capítulos:
Chapter 1: Index Fundamentals
Chapter 2: Index Storage Fundamentals
Chapter 3: Index Statistics
Chapter 4: XML, Spatial, and Full-Text Indexing
Chapter 5: Index Myths and Best Practices
Chapter 6: Index Maintenance
Chapter 7: Indexing Tools
Chapter 8: Index Strategies
Chapter 9: Query Strategies
Chapter 10: Index Analysis

Descarga:
Expert_Performance_Indexing_For_SQL_Server_2012