가야대학교 분성도서관
주메뉴
자료검색
- Home
- 상세정보
상세정보
부가기능
Learn T-SQL Querying : a Guide to Developing Efficient and Elegant T-SQL Code / [electronic resource]
상세 프로파일
| 자료유형 | E-Book |
|---|---|
| 개인저자 | Lopes, Pedro. Lahoud, Pam. |
| 서명/저자사항 | 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) |
| 소장본 주기 | Master record variable field(s) change: 050, 082, 630, 650 |
| 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. |
| 언어 | 영어 |
| 기타형태 저록 | Print version:Lopes, Pedro.Learn T-SQL Querying : A Guide to Developing Efficient and Elegant T-SQL Code.Birmingham : Packt Publishing, Limited, 짤20199781789348811 |
| 대출바로가기 | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2116995 |
소장정보
- 소장정보
인쇄
| No. | 등록번호 | 청구기호 | 소장처 | 도서상태 | 반납예정일 | 예약 | 서비스 | 매체정보 |
|---|---|---|---|---|---|---|---|---|
| 1 | WE00015575 | 005.75/85 | 가야대학교/전자책서버(컴퓨터서버)/ | 대출가능 |
|
카피라이터
