Pro T-SQL 2019 : Toward Speed, Scalability, and Standardization for SQL Server Developers /

Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, te...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Noble, Elizabeth (Database administrator) (Autor)
Autor Corporativo: Safari, an O'Reilly Media Company
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [United States] : Apress, 2020.
Edición:1st edition.
Temas:
SQL (Computer program language)
SQL (Langage de programmation)
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Intro
  • Table of Contents
  • About the Author
  • About the Technical Reviewer
  • Acknowledgments
  • Introduction
  • Part I: Building Understandable T-SQL
  • Chapter 1: Data Types
  • Number Data Types
  • Exact Number Data Types
  • BIT
  • TINYINT, SMALLINT, INT, BIGINT
  • DECIMAL/NUMERIC
  • SMALLMONEY, MONEY
  • Approximate Number Data Types
  • Converting Number Data Types
  • String Data Types
  • Character String Data Types
  • CHAR and VARCHAR
  • TEXT
  • Unicode String Data Types
  • NCHAR and NVARCHAR
  • NTEXT
  • Binary String Data Types
  • BINARY and VARBINARY
  • IMAGE
  • Date and Time Data Types
  • DATE
  • TIME
  • SMALLDATETIME, DATETIME, DATETIME2, DATETIMEOFFSET
  • Other Data Types
  • UNIQUEIDENTIFIER
  • XML
  • Spatial Geometry Types
  • Spatial Geography Types
  • SQL_VARIANT
  • Rowversion
  • HIERARCHYID
  • Table
  • Cursor
  • Chapter 2: Database Objects
  • Views
  • User-Defined Views
  • Indexed View
  • Functions
  • Scalar Functions
  • Table-Valued Functions
  • Inline Table-Valued Functions
  • Multi-statement Table-Valued Functions
  • Other User-Defined Objects
  • User-Defined Table Types
  • Table-Valued Parameters
  • Common Table Expressions
  • Temporary Objects
  • Temporary Tables
  • Local Temporary Tables
  • Global Temporary Tables
  • Persistent Temporary Table
  • Table Variables
  • Temporary Stored Procedures
  • Triggers
  • Logon Triggers
  • Data Definition Language (DDL) Triggers
  • Data Manipulation Language (DML) Triggers
  • Cursors
  • Forward-Only Cursors
  • Static Cursors
  • Keyset Cursors
  • Dynamic Cursors
  • Chapter 3: Standardizing T-SQL
  • Formatting T-SQL
  • Naming T-SQL
  • Commenting T-SQL
  • Chapter 4: Designing T-SQL
  • Using Stored Procedures
  • Using Parameters
  • Using Complex Logic
  • Part II: Building Performant T-SQL
  • Chapter 5: Set-Based Design
  • Introduction to Set-Based Design
  • Thinking in Data Sets
  • Writing Code for Data Sets
  • Chapter 6: Hardware Usage
  • Considering Memory with T-SQL Design
  • Considering Storage with T-SQL Design
  • Considering CPU with T-SQL Design
  • Chapter 7: Execution Plans
  • Reading Execution Plans
  • Index Usage in Execution Plans
  • Logical Join Types in Execution Plans
  • Chapter 8: Optimize T-SQL
  • Optimizing Logical Reads
  • Optimizing Duration
  • Automatic Database Tuning
  • Query Store
  • Automatic Plan Correction
  • Automatic Index Management
  • Intelligent Query Processing
  • Memory Grant Feedback
  • Batch Mode on Rowstore
  • Adaptive Joins
  • Part III: Building Manageable T-SQL
  • Chapter 9: Coding Standards
  • Why Use Coding Standards
  • What to Include in Coding Standards
  • T-SQL Design
  • ANSI STANDARD
  • Normal Form
  • Table Size
  • Name Value Pair
  • Primary Key
  • Foreign Key
  • Non-clustered Index
  • Constraint Definition
  • T-SQL Performance
  • Select Necessary Data
  • Sargeable
  • Implicit Conversion
  • SET NOCOUNT ON
  • NULL Values
  • NOLOCK
  • RECOMPILE
  • T-SQL Usability
  • Linked Server
  • Column Definition
  • BETWEEN

Ejemplares similares