| LDR | | 00000cam u2200205Ki 4500 |
| 001 | | 000000438982 |
| 005 | | 20200306171629 |
| 007 | | cr |n|---||||| |
| 008 | | 190511s2019 enk o 000 0 eng d |
| 019 | |
▼a 1100428148 |
| 020 | |
▼a 178934297X
▼q (electronic bk.) |
| 020 | |
▼a 9781789342970
▼q (electronic bk.) |
| 035 | |
▼a 2116995
▼b (N$T) |
| 035 | |
▼a (OCoLC)1101040978
▼z (OCoLC)1100428148 |
| 040 | |
▼a EBLCP
▼b eng
▼e pn
▼c EBLCP
▼d OCLCQ
▼d YDX
▼d UKAHL
▼d OCLCQ
▼d N$T
▼d 247004 |
| 050 | 4 |
▼a QA76.9.C55 |
| 082 | 04 |
▼a 005.75/85
▼2 23 |
| 100 | 1 |
▼a Lopes, Pedro. |
| 245 | 10 |
▼a Learn T-SQL Querying :
▼b a Guide to Developing Efficient and Elegant T-SQL Code/
▼c Pedro Lopes, Pam Lahoud.
▼h [electronic resource]. |
| 260 | |
▼a Birmingham:
▼b Packt Publishing, Limited,
▼c 2019. |
| 300 | |
▼a 1 online resource (473 pages). |
| 336 | |
▼a text
▼b txt
▼2 rdacontent |
| 337 | |
▼a computer
▼b c
▼2 rdamedia |
| 338 | |
▼a online resource
▼b cr
▼2 rdacarrier |
| 500 | |
▼a Complex expressions |
| 505 | 0 |
▼a 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 |
| 505 | 8 |
▼a 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 |
| 505 | 8 |
▼a 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* |
| 505 | 8 |
▼a 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 |
| 520 | |
▼a 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 |
| 520 | |
▼a 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. |
| 588 | 0 |
▼a Print version record. |
| 590 | |
▼a Master record variable field(s) change: 050, 082, 630, 650 |
| 630 | 00 |
▼a SQL server. |
| 650 | 0 |
▼a SQL (Computer program language) |
| 650 | 0 |
▼a Client/server computing. |
| 655 | 4 |
▼a Electronic books. |
| 700 | 1 |
▼a Lahoud, Pam, |
| 776 | 08 |
▼i Print version:
▼a Lopes, Pedro.
▼t Learn T-SQL Querying : A Guide to Developing Efficient and Elegant T-SQL Code.
▼d Birmingham : Packt Publishing, Limited, ©2019
▼z 9781789348811 |
| 856 | 40 |
▼3 EBSCOhost
▼u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2116995 |
| 938 | |
▼a Askews and Holts Library Services
▼b ASKH
▼n BDZ0040044133 |
| 938 | |
▼a ProQuest Ebook Central
▼b EBLB
▼n EBL5764473 |
| 938 | |
▼a YBP Library Services
▼b YANK
▼n 300508234 |
| 938 | |
▼a EBSCOhost
▼b EBSC
▼n 2116995 |
| 990 | |
▼a ***1008102 |
| 991 | |
▼a E-BOOK |
| 994 | |
▼a 92
▼b N$T |