MARC 닫기

• LDR

  00000cam c2200205 c 4500

• 001

  000001307491

• 005

  20201230141449

• 006

  m d

• 007

  cr |n|---|||||

• 008

  190511s2019 enk o 000a engd

• 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
  ▼c  EBLCP
  ▼d  OCLCQ
  ▼d  UKAHL
  ▼d  YDX
  ▼d  248023
  ▼d  OCLCQ
  ▼d  N$T
  ▼e  pn

• 049

  ▼a  MAIN

• 050

  ▼a  QA76.9.C55

• 082

  ▼a  005.75/85
  ▼2  23

• 100

  ▼a  Lopes, Pedro.

• 245

  ▼a  Learn T-SQL Querying
  ▼h  [electronic resource]:
  ▼b  a Guide to Developing Efficient and Elegant T-SQL Code/
  ▼d  Pedro Lopes, Pam Lahoud.

• 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

  ▼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

  ▼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

  ▼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

  ▼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

  ▼a  Print version record.

• 630

  ▼a  SQL server.

• 650

  ▼a  SQL (Computer program language)

• 650

  ▼a  Client/server computing.

• 655

  ▼a  Electronic books.

• 700

  ▼a  Lahoud, Pam.

• 776

  ▼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

  ▼3  EBSCOhost
  ▼u  http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2116995

• 990

  ▼a  강리원

• 991

  ▼a  eBook