Microsoft SQL Server 2005

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.

The most significant advances with SQL Server 2005, all with detailed treatment in this expanded hand book, include:
- Partitioning at the table and index level
- Online index management and recovery
- Mirrored databases (hot standby)
- Snapshots for flashback and recovery
- Clustering for processing power and failover
- Native XML data types and processing
- SQL Server Management Studio
- Databases Engine tuning Advisor
- Business Intelligence Development Studio

This book is for:
Microsoft SQL Database Administrators, Developers, and Systems Managers. Students, end users