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.
具体描述
读后感
用户评价
志国大叔推荐...
评分志国大叔推荐...
评分志国大叔推荐...
评分志国大叔推荐...
评分志国大叔推荐...
相关图书
本站所有内容均为互联网搜索引擎提供的公开搜索信息，本站不存储任何数据与内容，任何内容与数据均与本站无关，如有需要请联系相关搜索引擎包括但不限于百度，google,bing,sogou 等
© 2025 onlinetoolsland.com All Rights Reserved. 本本书屋 版权所有