Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook (Paperback)
Ken England Microsoft Certified Systems Engineer and a Microsoft Certified Trainer, Gavin JT Powell
- 出版商: Digital press
- 出版日期: 2007-04-01
- 售價: $2,820
- 貴賓價: 9.5 折 $2,679
- 語言: 英文
- 頁數: 520
- 裝訂: Paperback
- ISBN: 1555583199
- ISBN-13: 9781555583194
-
相關分類:
MSSQL、SQL
已過版
買這商品的人也買了...
-
Windows CE 嵌入式系統理論與實務$680$537 -
Microsoft SQL Server 2005: A Beginner's Guide (Paperback)$1,750$1,663 -
$399Microsoft SQL Server 2005 Developer's Guide (Paperback) -
SQL Server 2005 Bible$1,900$1,805 -
賴聲川的創意學$350$298 -
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET, 3/e (Paperback)$2,720$2,584 -
$399Pro SQL Server 2005 Database Design and Optimization (Paperback) -
$600Microsoft SQL Server 2005: Applied Techniques Step by Step (Paperback) -
A Developer's Guide to SQL Server 2005$2,520$2,394 -
Inside Microsoft SQL Server 2005: The Storage Engine (Paperback)$2,010$1,910 -
Microsoft SQL Server 2005 Administrator's Companion (Hardcover)$2,350$2,233 -
Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates and Types (Paperback)$1,900$1,805 -
Microsoft SQL Server 2005: The Complete Reference, 2/e (Paperback)$2,340$2,223 -
Beginning SQL Server2005 Administration (Paperback)$1,590$1,511 -
深入淺出物件導向分析與設計 (Head First Object-Oriented Analysis and Design)$880$616 -
How to Cheat at Securing SQL Server 2005 (Paperback)$2,180$2,071 -
Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers$2,060$1,957 -
Inside Microsoft SQL Server 2005: Query Tuning and Optimization$2,010$1,910 -
Professional SQL Server 2005 Performance Tuning$1,900$1,805 -
Professional Microsoft SQL Server 2008 Administration (Paperback)$2,420$2,299 -
Microsoft SQL Server 2008 Bible (Paperback)$2,600$2,470 -
ASP .NET Programming with C# & SQL Server (Paperback)$6,400$6,080 -
Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring (Paperback)$1,960$1,862 -
Microsoft SQL Server 2008 R2 Unleashed (Paperback)$2,350$2,233 -
踏入雲端虛擬化的第一步－VMware vSphere 5 企業建置教戰手扎(附教學影片)$580$464
相關主題
商品描述
Description
Database professionals will find that this new edition aids in mastering the latest version of Microsoft’s 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.
Table of contents
Introduction and Acknowledgements
Chapter 1. Performance and SQL Server 2005
Chapter 2. Logical database design for performance
Chapter 3. Physical database design
Chapter 4. SQL Server storage structures
Chapter 5. Indexing
Chapter 6. Basic query tuning
Chapter 7. What is query optimization?
Chapter 8. Investigating and influencing the optimizer
Chapter 9. SQL Server 2005 and Windows 2003
Chapter 10. Transactions and locking
Chapter 11. Performance and architectural choices
Chapter 12. Monitoring performance
Appendices
Appendix A – Syntax Conventions
Appendix B – Database Scripts
Appendix C - Performance Strategies and Tuning Checklist
