소장자료
LDR | 05212cam a2200541Ki 4500 | ||
001 | 0100460579▲ | ||
003 | OCoLC▲ | ||
005 | 20220427155929▲ | ||
006 | m d ▲ | ||
007 | cr |n|---|||||▲ | ||
008 | 190511s2019 enk o 000 0 eng d▲ | ||
019 | ▼a1100428148▲ | ||
020 | ▼a178934297X▼q(electronic bk.)▲ | ||
020 | ▼a9781789342970▼q(electronic bk.)▲ | ||
035 | ▼a2116995▼b(N$T)▲ | ||
035 | ▼a(OCoLC)1101040978▼z(OCoLC)1100428148▲ | ||
040 | ▼aEBLCP▼beng▼epn▼cEBLCP▼dOCLCQ▼dYDX▼dUKAHL▼dOCLCQ▼dN$T▲ | ||
050 | 4 | ▼aQA76.9.C55▲ | |
082 | 0 | 4 | ▼a005.75/85▼223▲ |
100 | 1 | ▼aLopes, Pedro.▲ | |
245 | 1 | 0 | ▼aLearn T-SQL Querying :▼ba Guide to Developing Efficient and Elegant T-SQL Code /▼cPedro Lopes, Pam Lahoud.▼h[electronic resource]▲ |
260 | ▼aBirmingham :▼bPackt Publishing, Limited,▼c2019.▲ | ||
300 | ▼a1 online resource (473 pages)▲ | ||
336 | ▼atext▼btxt▼2rdacontent▲ | ||
337 | ▼acomputer▼bc▼2rdamedia▲ | ||
338 | ▼aonline resource▼bcr▼2rdacarrier▲ | ||
500 | ▼aComplex expressions▲ | ||
505 | 0 | ▼aCover; 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▲ | |
505 | 8 | ▼aSimple 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▲ | |
505 | 8 | ▼aAccessing 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*▲ | |
505 | 8 | ▼aMemoryGrantInfoOptimization 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▲ | |
520 | ▼aChapter 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▲ | ||
520 | ▼aT-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.▲ | ||
588 | 0 | ▼aPrint version record.▲ | |
590 | ▼aMaster record variable field(s) change: 050, 082, 630, 650▲ | ||
630 | 0 | 0 | ▼aSQL server.▲ |
650 | 0 | ▼aSQL (Computer program language)▲ | |
650 | 0 | ▼aClient/server computing.▲ | |
655 | 4 | ▼aElectronic books.▲ | |
700 | 1 | ▼aLahoud, Pam.▲ | |
776 | 0 | 8 | ▼iPrint version:▼aLopes, Pedro.▼tLearn T-SQL Querying : A Guide to Developing Efficient and Elegant T-SQL Code.▼dBirmingham : Packt Publishing, Limited, ©2019▼z9781789348811▲ |
856 | 4 | 0 | ▼3EBSCOhost▼uhttp://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2116995▼g7▲ |
938 | ▼aAskews and Holts Library Services▼bASKH▼nBDZ0040044133▲ | ||
938 | ▼aProQuest Ebook Central▼bEBLB▼nEBL5764473▲ | ||
938 | ▼aYBP Library Services▼bYANK▼n300508234▲ | ||
938 | ▼aEBSCOhost▼bEBSC▼n2116995▲ | ||
994 | ▼a92▼bN$T▲ |
![](https://lib.pusan.ac.kr/wp-content/themes/pnul2022/assets/images/default/default_w_279X393.png)
Learn T-SQL Querying : a Guide to Developing Efficient and Elegant T-SQL Code
자료유형
국외eBook
서명/책임사항
Learn T-SQL Querying : a Guide to Developing Efficient and Elegant T-SQL Code / Pedro Lopes, Pam Lahoud. [electronic resource]
발행사항
Birmingham : Packt Publishing, Limited , 2019.
형태사항
1 online resource (473 pages)
일반주기
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
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./
기타형태저록
ISBN
178934297X 9781789342970
관련 인기대출 도서