T-SQL Querying
- ISBN-10
- 0133986624
- ISBN-13
- 9780133986624
- Category
- Computers
- Pages
- 864
- Language
- English
- Published
- 2015-02-17
- Publisher
- Microsoft Press
- Authors
- Adam Machanic, Dejan Sarka, Itzik Ben-Gan
Description
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. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012. Write faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation techniques, including new grouping sets Efficiently perform data-analysis calculations Make the most of T-SQL’s optimized bulk import tools Avoid date/time pitfalls that lead to buggy, poorly performing code Create optimized BI statistical queries without additional software Use programmable objects to accelerate queries Unlock major performance improvements with In-Memory OLTP Master useful and elegant approaches to manipulating graphs About This Book For experienced T-SQL practitioners Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming Valuable to developers, DBAs, BI professionals, and data scientists Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics
Get the book
Other editions
Similar books
-
Inside Microsoft SQL Server 2008 T-SQL Querying: T-SQL Querying
By Dejan Sarka, Itzik Ben-Gan, Lubor KollarTackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL.
-
T-SQL Fundamentals
By Itzik Ben-GanItzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL’s roots and underlying logic.
-
Learn T-SQL Querying: A guide to developing efficient and elegant T-SQL code
By Pedro Lopes, Pam LahoudThis book will be a useful guide to learning the art of writing efficient T-SQL code in modern SQL Server versions, as well as the Azure SQL Database.
-
Learn T-SQL From Scratch: An Easy-to-Follow Guide for Designing, Developing, and Deploying Databases in the SQL Server and Writing T-SQL...
By Brahmanand ShuklaDESCRIPTION This book will teach you the fundamentals of SQL, SQL Server, databases, and how to write queries and programs using T-SQL. After reading this book, you will be able to create, modify, and delete databases, tables, and indexes.
-
Inside Microsoft SQL Server 2008: T-SQL Querying
By Itzik Ben-GanTackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and...
-
100+ SQL Queries T-SQL for Microsoft SQL Server
By I.F.S. HarrisonOver 100 examples of SQL queries and statements along with images of results will help you learn T SQL. A special section included in this illustrated guide will help you test your skills and get ahead in the workplace.
-
Exam Ref 70-761 Querying Data with Transact-SQL
By Itzik Ben-GanFocus on the expertise measured by these objectives: • Filter, sort, join, aggregate, and modify data • Use subqueries, table expressions, grouping sets, and pivoting • Query temporal and non-relational data, and output XML or JSON ...
-
Learn T-SQL Querying: A guide to developing efficient and elegant T-SQL code
By Pedro Lopes, Pam LahoudTroubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers Key Features A definitive guide to mastering the techniques of writing efficient T-SQL code ...
-
Microsoft SQL Server 2012 T-SQL Fundamentals
By Itzik Ben-GanPresents information on the fundamentals of T-SQL to develop code and query and modify data in Microsoft SQL Server 2012.
-
Inside Microsoft SQL Server 2005: T-SQL Querying
By Dejan Sarka, Itzik Ben-Gan, Lubor KollarTake a detailed look at the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from the experts.