Delve into the internal architecture of T-SQL and unveil the power of set-based querying with comprehensive reference and advice from a highly regarded T-SQL expert and members of Microsoft's SQL Server development team. Database developers and administrators will examine the best practices, advanced techniques, sample databases, and code needed to master the programming language built into SQL Server solving complex problems with real-world solutions. Understand logical and physical query processing Learn about set theory, predicate logic, and the relational model Apply a methodology to optimize query tuning Analyze the algorithmic complexity of your queries Solve relational division problems Use CTEs and ranking functions to simplify and optimize solutions Aggregate data with various techniques, including tiebreakers, pivoting, histograms, grouping factors, and grouping sets Use the TOP option to query and modify data Use the MERGE statement to modify data based on conditional logic Maintain and query graph structures with the HIERARCHYID datatype, recursive queries, and other solutions PLUS Improve your logic and get to the heart of querying problems with logic puzzles All the book s code samples will be available for download from the companion Web site.
Inside Microsoft® SQL Server® 2008: T-SQL Querying
- Authors
- Itzik BenGan, Lubor Kollar, Dejan Sarka, Steve Kass
- ISBN
- 0735626030
- Published
- 25 Mar 2009
- Purchase online
- amazon.com
Delve into the internal architecture of T-SQL and unveil the power of set-based querying with comprehensive reference and advice from a highly regarded T-SQL expert and members of Microsoft's SQL Server development team. Database developers and administrators will examine the best practices, advanced techniques, sample databases, and code needed to master the programming language built into SQL Server solving complex problems with real-world solutions.
- Editorial Reviews
- Customer Reviews
Editorial Reviews
You might also like...
SQL Server books
-
Database Systems: Design, Implementation, and Management
Database Systems: Design, Implementation, and Management, Eighth Edition, a market-leader for database texts, gives readers a solid foundation in practical database design and implementation. The book provides in-depth coverage of database design, de...
SQL Server podcasts
-
The SitePoint Podcast: Mining the Database
Published 8 years ago, running time 0h29m
Episode 179 of The SitePoint Podcast is now available! This week we have 3/4 of the panel, Louis Simoneau (@rssaddict), Patrick O’Keefe (@ifroggy) and Stephan Segraves (@ssegraves). Listen in Your Browser Play this episode directly in your browser — just click the orange “play” button below: Down.
Comments