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.
Key Book Benefits:
- Delivers practical, hands-on guidance on sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much more
- Provides deep background information that helps developers optimize queries, aggregate data, and develop hierarchies and recursive queries
- Helps promote mastery of T-SQL
- Features numerous code and table examples, practical advice, logic puzzles, and best practices
About the Author
The primary author, Itzik Ben-Gan, is a Principal Mentor and Founder of Solid Quality Learning. A SQL Server Microsoft Most Valuable Professional (MVP) since 1999, Itzik has delivered dozens of training events across the U.S. and Europe focused on T-SQL programming, performance tuning and internals, administration, implementation, data warehousing, and online analytical processing (OLAP). An accomplished author, Itzik has written many articles for SQL Server Magazine, as well as articles and white papers for MSDN®. Itzik’s speaking activities have included Tech·Ed, DevWeek, PASS, SQL Server Connections, and SQLU Summits, to name a few.
Lubor Kollar is a program manager on the SQL Server team at Microsoft Corporation who focuses on optimization.
Dejan Sarka is a Solid Quality Learning Associate Mentor.