作者：Ken England, Gavin JT Powell
出版日期：April 13, 2007
出版社：其它
页数：520
ISBN：ISBN-10: 1555583199 ISBN-13: 978-1555583194
文件格式：PDF


Book Description
Essential and up-to-date information on Microsoft’s SQL Server 2005 for any database developer or administrator!
Product Description
Database professionals will find that this new edition aids inmastering the latest version of Microsoft’s SQL Server. Developers anddatabase administrators (DBAs) use SQL on a daily basis in applicationdevelopment and the subsequent problem solving and fine tuning. Answersto SQL issues can be quickly located helping the DBA or developeroptimize 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 regularexpressions. 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 inenterprise environments to resolve common and specialized problems tooptimization issues.
* Addresses issues that have been introduced by new features which can add more control but reduce performance.