T-SQL Querying (Developer Reference)
Mega Sale! Save 23% on the T-SQL Querying (Developer Reference) by Microsoft Press at EMS Linux. Hurry! Limited time offer. Offer valid only while supplies last. T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from every T-SQL query you
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:
About This Book
- 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
- 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
|Item Weight:||0 pounds|
|Item Size:||1.9 x 9 x 9 inches|
|Package Weight:||3.15 pounds|
|Package Size:||7.3 x 1.8 x 1.8 inches|
Have questions about this item, or would like to inquire about a custom or bulk order?
If you have any questions about this product by Microsoft Press, contact us by completing and submitting the form below. If you are looking for a specif part number, please include it with your message.
Related Best Sellers
By Sams Publishing
ean: 9780672337437, isbn: 0672337436,
Sams Teach Yourself T-sql in One Hour a Day...
By Rankins, Ray/ Bertucci, Paul/ Gallelli, Chris/ Silverstein, Alex T.
mpn: 9780672330568, ean: 9780672330568, isbn: 0672330563,
This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reportin...
By Sams Publishing
ean: 9780672324680, isbn: 0672324687,
Microsoft SQL Server 2000 DBA Survival Guide is organized into several parts that comprise the various jobs and tasks the DBA performs. Each chapter is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL ...
Title: Exam 70-463( Implementing a Data Warehouse with Microsoft SQL Server 2012 Training Kit [With CDROM]) Binding: Paperback Author: DejanSarka Publisher: MicrosoftPress...
mpn: 9781590599990, ean: 9781590599990, isbn: 1590599993,
Service Broker is a key Microsoft product in support of message–based processing between applications. Pro SQL Server 2008 Service Broker helps you to take full advantage of this key Microsoft technology, beginning from the fundamentals, moving thr...
mpn: 9781430215943, ean: 9781430215943, isbn: 1430215941,
Businesses today want actionable insights into their data―they want their data to reveal itself to them in a natural and user–friendly form. What could be more natural than human language? Natural–language search is at the center of a storm of ...
By Delaney, Kalen
mpn: 978-0-7356-2624-9, ean: 9780735626249, isbn: 0735626243,
Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key ar...
mpn: 978-0-7356-2618-8, ean: 9780735626188, isbn: 0735626189,
Teach yourself the Multidimensional Expressions (MDX) query language—one step at a time. With this practical, learn-by-doing tutorial, you’ll build the core techniques for using MDX with Analysis Services to deliver high-performance business inte...
mpn: illustrations, ean: 9781893115194, isbn: 1893115194,
The most comprehensive and detailed VB/ADO book available, placing developers firmly in control of Microsoft's premier data access technology. The first part goes beyond the syntax of ADO to help developers gain an understanding of ADO components, wh...
By Little Brown
mpn: 0-7356-1129-7, ean: 9780735611290, isbn: 0735611297,