상세정보
Export to Refworks부가기능
Learn T-SQL Querying [electronic resource] a Guide to Developing Efficient and Elegant T-SQL Code
상세 프로파일
| 자료유형 | 단행본 |
|---|---|
| 서명/저자사항 | Learn T-SQL Querying : a Guide to Developing Efficient and Elegant T-SQL Code/ Pedro Lopes, Pam Lahoud. [electronic resource]. |
| 개인저자 | Lopes, Pedro. Lahoud, Pam, |
| 발행사항 | Birmingham: Packt Publishing, Limited, 2019. |
| 형태사항 | 1 online resource (473 pages). |
| 기타형태 저록 | Print version: Lopes, Pedro. Learn T-SQL Querying : A Guide to Developing Efficient and Elegant T-SQL Code. Birmingham : Packt Publishing, Limited, ©2019 9781789348811 |
| ISBN | 178934297X 9781789342970 |
| 일반주기 |
Complex expressions
|
| 내용주기 | Cover; Title Page; Copyright and Credits; About Packt; Foreword; Contributors; Table of Contents; Preface; Section 1: Query Processing Fundamentals; Chapter 1: Anatomy of a Query; Building blocks of a T-SQL statement; SELECT; DISTINCT; TOP; FROM; INNER JOIN; OUTER JOIN; CROSS JOIN; APPLY; WHERE; ORDER BY; GROUP BY; HAVING; Logical statement processing flow; Summary; Chapter 2: Understanding Query Processing; Query compilation essentials; Query optimization essentials; Query execution essentials; Plan caching and reuse; Stored procedures; Ad hoc plan caching; Parameterization Simple parameterizationForced parameterization; The sp_executesql procedure; Prepared statements; How query processing impacts plan reuse; The importance of parameters; Security; Performance; Parameter sniffing; To cache or not to cache; Summary; Chapter 3: Mechanics of the Query Optimizer; Introducing the Cardinality Estimator; Understanding the query optimization workflow; The Trivial Plan stage; The Exploration stage; Transaction Processing; Quick plan; Full optimization; Knobs for query optimization; Summary; Section 2: Dos and Donts of T-SQL; Chapter 4: Exploring Query Execution Plans Accessing a query planNavigating a query plan; Query plan operators of interest; Blocking versus non-blocking operators; Data-access operators; Table Scan; Clustered Index Scan; NonClustered Index Scan; NonClustered Index Seek; Clustered Index Seek; Lookups; RID Lookups; Key Lookups; Columnstore Index Scan; Joins; Nested Loops joins; Merge Joins; Hash Match joins; Adaptive Joins; Spools; Sorts and aggregation; Sorts; Stream aggregation; Hash aggregation; Query plan properties of interest; Plan-level properties; Cardinality estimation model version; Degree of Parallelism*; Memory Grant* MemoryGrantInfoOptimization Level; OptimizerHardwareDependentProperties; OptimizerStatsUsage; QueryPlanHash; QueryHash; Set options; Statement; TraceFlags; WaitStats; QueryTimeStats*; MissingIndexes; Parameter List; Warnings*; PlanAffectingConvert; WaitForMemoryGrant*; MemoryGrantWarning*; SpatialGuess*; UnmatchedIndexes*; FullUpdateForOnlineIndexBuild; Operator-level properties; RunTimeCountersPerThread; Actual I/O Statistics*; Actual Number of Rows; Actual Time Statistics; Estimated rows; EstimateRowsWithoutRowGoal; Warnings*; Columns With No Statistics*; Spill To TempDb; No Join Predicate |
| 요약 | Chapter 5: Writing Elegant T-SQL Queries; Understanding predicate SARGability; Basic index guidelines; Clustered indexes; Non-clustered indexes; INCLUDE columns; Filtered indexes; Unique versus non-unique; Columnstore indexes; Indexing strategy; Data structure considerations; Database usage considerations; Query considerations; Best practices for T-SQL querying; Referencing objects; Joining tables; Using NOLOCK; Using cursors; Summary; Chapter 6: Easily-Identified T-SQL Anti-Patterns; The perils of SELECT *; Functions in our predicate; Deconstructing table-valued functions |
| 요약 | T-SQL is an extension of the SQL language which allows you to tackle advanced querying and query-tuning challenges in SQL Server and Azure SQL Database. This book will be a perfect reference for you to write more efficient T-SQL code to perform simple-to-advanced tasks for data management and data analysis. |
| 주제명 (통일서명) | SQL server. |
| 일반주제명 | SQL (Computer program language) Client/server computing. |
| 언어 | 영어 |
| 바로가기 |  |
