• Title T-SQL Querying
• Author(s) Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
• Publisher: Microsoft Press; 1st edition (March 6, 2015)
• Paperback: 864 pages
• eBook: PDF
• Language: English
• ISBN-10: 0735685045
• ISBN-13: 978-0735685048
• Share This:  

Book Description

Transact-SQL (T-SQL)insiders help you tackle your toughest queries and query-tuning problems. Squeeze maximum performance and efficiency from every T-SQL query you write or tune.

• N/A

• Amazon

• Miscrosoft SQL Server
• Sybase SQL Server
• SQL - The Structured Query Language
• Microsoft Windows and .NET

• Learn T-SQL Querying (Itzik Ben-Gan, , et al.)
• The Mirror Site (1) - PDF
• The Mirror Site (2) - PDF

• Transact-SQL: The Building Blocks to SQL Server Programming

  This book will cover different aspects of the Transact SQL (TSQL) language. It takes the readers step by step through the TSQL language, one concept at a time. Each topic covers a particular aspect of TSQL with discussion and examples.

• SQL Performance Explained: Everything Developers Need to Know

  Starting with the basics of indexing and the WHERE clause, this book guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.

• SQL Server Execution Plans, 3rd Edition (Grant Fritchey)

  This book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans, leads you right from the basics of capturing plans to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

• SQL Server Concurrency: Locking, Blocking and Row Versioning

  This book is for anyone using SQL Server as a programmer, an administrator, or even a user, who wants to understand how SQL Server manages multiple sessions, and what causes excessive blocking.

• SQL The Complete Reference (James R. Groff, et al.)

  Get comprehensive coverage of every aspect of SQL from three leading industry experts. This one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications.

• Introduction to SQL (Bobby Iliev)

  SQL knowledge is essential for anyone involved in programming, data science, and data management. This is an introduction to SQL that will help you learn the basics of SQL and start using relational databases for your SysOps, DevOps, and Dev projects.

• SQL Queries Succinctly (Nick Harrison)

  This book shows you how to craft queries in SQL, from basic CRUD statements and slicing and dicing the data, to applying filters and using aggregate functions to summarize the data, solving common problems, navigating hierarchical data, etc.