| Description |
1 online resource (xvi, 499 pages) : illustrations |
| Summary |
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 quickly located helping the DBA or developer optimize and tune a database to maximum efficiency. Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions. Assistance on DML, data types (including collections), XML, DDL for basic database objects such as tales, views and indexes, partitioning, and security is also considered. * Identifies the most common issues DBAs face day to day for easy reference *Provides DBAs with solutions actually used by the authors in enterprise environments to resolve common and specialized problems to optimization issues. * Addresses issues that have been introduced by new features which can add more control but reduce performance. |
| Contents |
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 |
| Subject |
SQL server.
|
|
SQL server. |
|
SQL server |
|
Client/server computing.
|
|
Relational databases.
|
|
Architecture client-serveur (Informatique) |
|
Bases de données relationnelles. |
|
Client/server computing |
|
Relational databases |
| Added Author |
Powell, Gavin.
|
| Other Form: |
Print version: England, Ken, 1955- Microsoft SQL Server 2005 performance optimization and tuning handbook. Boston, Mass. ; Oxford : Digital, 2007 9781555583194 1555583199 (OCoLC)137222382 |
| ISBN |
9781555583194 |
|
1555583199 |
|
9780080554082 |
|
0080554083 |
|
More Resources