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: <ul>
<li>Move from procedural programming to the language of sets and logic</li> <li>Master an efficient top-down tuning methodology</li> <li>Assess algorithmic complexity to predict performance</li> <li>Compare data aggregation techniques, including new grouping sets</li> <li>Efficiently perform data-analysis calculations</li> <li>Make the most of T-SQL’s optimized bulk import tools</li> <li>Avoid date/time pitfalls that lead to buggy, poorly performing code</li> <li>Create optimized BI statistical queries without additional software</li> <li>Use programmable objects to accelerate queries</li> <li>Unlock major performance improvements with In-Memory OLTP</li> <li>Master useful and elegant approaches to manipulating graphs</li> </ul>
 About This Book <ul>
<li>For experienced T-SQL practitioners</li> <li>Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming </li> <li>Valuable to developers, DBAs, BI professionals, and data scientists</li> <li>Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics</li> </ul>

T-SQL Querying (Developer Reference)

Computers & Technology

Sarka, Dejan

Ben-Gan, Itzik

Machanic, Adam

Farlee, Kevin

Programming

Microsoft Press

While building on the skills you already have, Expert SQL Server 2005 Development will help you become an even better developer by focusing on best practices and demonstrating how to design high–performance, maintainable database applications. This book starts by reintroducing the database as a integral part of the software development ecosystem. You'll learn how to think about SQL Server development as you would any other software development. For example, there's no reason you can't architect and test database routines just as you would architect and test application code. And nothing should stop you from implementing the types of exception handling and security rules that are considered so important in other tiers, even if they are usually ignored in the database. You'll learn how to apply development methodologies like these to produce high–quality encryption and SQLCLR solutions. Furthermore, you'll discover how to exploit a variety of tools that SQL Server offers in order to properly use dynamic SQL and to improve concurrency in your applications. Finally, you'll become well versed in implementing spatial and temporal database designs, as well as approaching graph and hierarchy problems.

Expert SQL Server 2005 Development

Rubbelke, Lara

Kornelis, Hugo

Networking & Cloud Computing

Apress

This is not an ordinary SQL Server Book. SQL Server MVP Deep Dives brings together the world's most highly-regarded SQL Server experts to create a masterful collection of tips, techniques, and experience-driven best practices for SQL Server development and administration. These SQL Server MVPs-53 in all-each selected a topic of great interest to them, and in this unique book, they share their knowledge and passion with you. SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. Within each part, you'll find a collection of brilliantly concise and focused chapters that take on key topics like mobile data strategies, Dynamic Management Views, or query performance. The range of subjects covered is comprehensive, from database design tips to data profiling strategies for BI. Additionally, the authors of this book have generously donated 100% of their royalties to support War Child International. War Child International is a network of independent organizations, working across the world to help children affected by war. War Child was founded upon a fundamental goal: to advance the cause of peace through investing hope in the lives of children caught up in the horrors of war. War Child works in many different conflict areas around the world, helping hundreds of thousands of children every year. Visit www.warchild.org for more information. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

SQL Server MVP Deep Dives

Nielsen, Paul

Delaney, Kalen

Tripp, Kimberly

Randal, Paul

Low, Greg

Manning

See the best price to sell, buy, or rent books by Machanic, Adam. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Machanic, Adam