Boek
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 processingLearn about set theory, predicate logic, and the relational modelApply a methodology to optimize query tuningAnalyze the algorithmic complexity of your queriesSolve relational division problemsUse CTEs and ranking functions to simplify and optimize solutionsAggregate data with various techniques, including tiebreakers, pivoting, histograms, grouping factors, and grouping setsUse the TOP option to query and modify dataUse the MERGE statement to modify data based on conditional logicMaintain and query graph structures with the HIERARCHYID datatype, recursive queries, and other solutionsPLUS - Improve your logic and get to the heart of querying problems with logic puzzlesAll the book's code samples will be available for download from the companion Web site. «
Boeklezers.nl is een netwerk voor sociaal lezen. Wij helpen lezers nieuwe boeken en schrijvers ontdekken, en brengen lezers met elkaar en schrijvers in contact. Meer lezen »
Er zijn nog geen recensies voor dit boek.