Cargando…
Microsoft SQL Server 2005 performance optimization and tuning handbook /
Database professionals will find that this new edition aids in mastering the latest version of Microsofts SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be qui...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Boston, Mass. ; Oxford :
Digital,
2007.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Front Cover; Microsoft� SQL ServerTM 2005 Performance Optimization and Tuning Handbook; Copyright Page; Contents; Introduction; Chapter 1. Performance and SQL Server 2005; 1.1 Partitioning tables and indexes; 1.2 Building indexes online; 1.3 Transact SQL improvements; 1.4 Adding the .NET Framework; 1.5 Trace and replay objects; 1.6 Monitoring resource consumption with SQL OS; 1.7 Establishing baseline metrics; 1.8 Start using the GUI tools; 1.9 Availability and scalability; 1.10 Other useful stuff; 1.11 Where to begin?; Chapter 2. Logical Database Design for Performance
- 2.1 Introducing logical database design for performance2.2 Commercial normalization techniques; 2.3 Denormalization for performance; 2.4 Extreme denormalization in data warehouses; Chapter 3. Physical Database Design; 3.1 Introducing physical database design; 3.2 Data volume analysis; 3.3 Transaction analysis; 3.4 Hardware environment considerations; Chapter 4. SQL Server Storage Structures; 4.1 Databases and files; 4.2 Creating databases; 4.3 Increasing the size of a database; 4.4 Decreasing the size of a database; 4.5 Modifying filegroup properties; 4.6 Setting database options
- 4.7 Displaying information about databases4.8 System tables used in database configuration; 4.9 Units of storage; 4.10 Database pages; 4.11 Looking into database pages; 4.12 Pages for space management; 4.13 Partitioning tables into physical chunks; 4.14 The BankingDB database; Chapter 5. Indexing; 5.1 Data retrieval with no indexes; 5.2 Clustered indexes; 5.3 Non-clustered indexes; 5.4 Online indexes; 5.5 The more exotic indexing forms; 5.6 The role of indexes in insertion and deletion; 5.7 A note with regard to updates; 5.8 So how do you create indexes?; 5.9 Dropping and renaming indexes
- 5.10 Displaying information about indexes5.11 Creating indexes on views; 5.12 Creating indexes with computed columns; 5.13 Using indexes to retrieve data; 5.14 Choosing indexes; Chapter 6. Basic Query Tuning; 6.1 The SELECT statement; 6.2 Using functions; 6.3 Comparison conditions; 6.4 Joins; 6.5 Using subqueries for efficiency; 6.6 Specialized metadata objects; 6.7 Procedures in Transact SQL; Chapter 7. What Is Query Optimization?; 7.1 When is a query optimized?; 7.2 The steps in query optimization; 7.3 Query analysis; 7.4 Index selection; 7.5 Join order selection
- 7.6 How joins are processedChapter 8. Investigating and Influencing the Optimizer; 8.1 Text-based query plans and statistics; 8.2 Query plans in Management Studio; 8.3 Hinting to the optimizer; 8.4 Stored procedures and the query optimizer; 8.5 Non-stored procedure plans; 8.6 The syscacheobjects system table; Chapter 9. SQL Server and Windows; 9.1 SQL Server and CPU; 9.2 SQL Server and memory; 9.3 SQL Server and disk I/O; Chapter 10. Transactions and Locking; 10.1 Why a locking protocol?; 10.2 The SQL Server locking protocol; 10.3 SQL Server locking in action