Inside Microsoft SQL Server 2005: T-SQL Querying

632 pages. This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)one of t he 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. Youll get in -depth coverage of the sophisticated uses of T-SQL, including the differences be tween logical and physical processing, nesting of queries, and much more. The bo ok explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features a dded to SQL Server 2005 in detail. Includes extensive code samples, table exampl es, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL.