A comprehensive, hands-on reference for database developers and administrators, this book focuses on advanced querying techniques using Transact-SQL (T-SQL), the database programming language built into SQL Server. Includes code and table examples. This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)--one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on advanced querying techniques and how queries are interpreted and processed by the SQL Server execution engine. You'll get in-depth coverage of the sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL. SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers enhanced scalability, availability, and security features to enterprise data and analytical applications while making them easier to create, deploy, and manage. Featuring key advances in enterprise data management, developer productivity, and business intelligence, SQL Server 2005 is part of the Microsoft Windows Server System, a comprehensive and integrated server infrastructure that simplifies the development, deployment, andoperations of flexible business solutions.

This resource for programmers and database administrators describes the internal architecture of Transact-SQL (T-SQL), the primary query language used in Microsoft SQL Server. For each of the practical coding problems discussed, several approaches for solving them are described. Topics include (for example) logical and physical query processing; query tuning; joins and set operations; and aggregating and pivoting data. Ben-Gan (Solid Quality Learning) has been a Microsoft MVP for SQL Server since 1999. Annotation ©2007 Book News, Inc., Portland, OR (booknews.com)