|
 |
|
 |
 |
Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
|
by Ken England and Gavin JT Powell
Sales Rank: 591079
|
Discount: 30 %
$37.27
At Amazon
|
|
Paperback: 520 pages
Publisher: Digital Press April 13, 2007
Language: English
ISBN-10: 1555583199
ISBN-13: 978-1555583194
Product Dimensions:
8.9 x 7.6 x 1.1 inches
Shipping Weight: 2.3 pounds
Book Description
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.
About The Author
Ken England is President and Founder of Database Technologies, a database consulting, product evaluation and training firm. A Microsoft Certified Systems Engineer and a Microsoft Certified Trainer, Ken England is widely regarded as an authority on SQL Server and other leading database products. He is also the author of the SQL Server 6.5 Performance Optimization and Tuning Handbook. Gavin Powell, BSc. Comp.Sci., OCP (Oracle8i Certified Professional) has fifteen years of computer industry experience. Diverse experience in database administration and database development in both relational and object databases. Applications development experience is procedural and object-oriented. He also has some systems administration experience. His extensive consulting experience includes software vendors, internet .COMs (some unfortunately have met with their demise), accounting, banking, financial services, the travel industry, construction, retail, mining, shipping, education and general advisory capacity. Gavin Powell has worked with many software products, tools and programming languages. These tools include items in the list shown below. He has authored two successful books Oracle High performance Tuning and the just released Oracle SQL
Customer Reviews & Comments
I know Ken England well. Although his name is on the book he did not write it. He stopped writing books with his SQL Server 2000 Performance Edition. This all came as an unpleasant surprise to him as not only did he not write any new material for the 2005 book but he did not even get sent a copy of the book to proof. He told me it's not great to see your name on a book you have neither written nor read but publishers apparently reserve the (legal) right to do this!
Comment | Permalink |
(Report this)
|
Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
Discount: 30 %
Available from Amazon
Price: $37.27
| |
|
|
|
|
