Advertisement

Pro T-SQL 2019

Toward Speed, Scalability, and Standardization for SQL Server Developers

  • Elizabeth┬áNoble
Book

Table of contents

  1. Front Matter
    Pages i-xvii
  2. Building Understandable T-SQL

    1. Front Matter
      Pages 1-1
    2. Elizabeth Noble
      Pages 3-23
    3. Elizabeth Noble
      Pages 25-72
    4. Elizabeth Noble
      Pages 73-95
    5. Elizabeth Noble
      Pages 97-120
  3. Building Performant T-SQL

    1. Front Matter
      Pages 121-121
    2. Elizabeth Noble
      Pages 123-146
    3. Elizabeth Noble
      Pages 147-162
    4. Elizabeth Noble
      Pages 163-194
    5. Elizabeth Noble
      Pages 195-217
  4. Building Manageable T-SQL

    1. Front Matter
      Pages 219-219
    2. Elizabeth Noble
      Pages 221-242
    3. Elizabeth Noble
      Pages 243-265
    4. Elizabeth Noble
      Pages 267-288
    5. Elizabeth Noble
      Pages 289-312
  5. Building Maintainable T-SQL

    1. Front Matter
      Pages 313-313
    2. Elizabeth Noble
      Pages 315-343
    3. Elizabeth Noble
      Pages 345-360
    4. Elizabeth Noble
      Pages 361-398
  6. Back Matter
    Pages 399-406

About this book

Introduction

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, testing, and deployment strategies. 

Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward. 

You will:
  • Choose correct data types and database objects when designing T-SQL
  • Write T-SQL that searches data efficiently and uses hardware effectively
  • Implement source control and testing methods to streamline the deployment process
  • Design T-SQL that can be enhanced or modified with less effort
  • Plan for long-term data management and storage

Keywords

SQL Server Relational Database Database Development SQL Structured Query Language Transact-SQL Stored Procedures Thinking in Sets Execution Plans Database Tuning Indexing Unit Testing Integration Testing Security T-SQL Querying Advanced SQL Programming Joe Celko's SQL for Smarties

Authors and affiliations

  • Elizabeth┬áNoble
    • 1
  1. 1.RoswellUSA

Bibliographic information