T-SQL Querying

Nonfiction, Computers, Database Management
Cover of the book T-SQL Querying by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee ISBN: 9780133986624
Publisher: Pearson Education Publication: February 17, 2015
Imprint: Microsoft Press Language: English
Author: Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
ISBN: 9780133986624
Publisher: Pearson Education
Publication: February 17, 2015
Imprint: Microsoft Press
Language: English

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
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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

More books from Pearson Education

Cover of the book Law Express: Scottish Business Law (Revision guide) by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Brilliant Personal Finances by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Windows Presentation Foundation Unleashed by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Start a Business for £99 by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Smart Business, Social Business by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Using Google AdWords and AdSense by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Epigenetics in Health and Disease by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Peoplesoft HRMS Reporting by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Microsoft SharePoint 2013 Planning for Adoption and Governance by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book CCIE Routing and Switching v5.0 Official Cert Guide, Volume 2 by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Cisco Unity Fundamentals by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Forex Revolution by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Urban Exploration Photography by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Saving for Retirement (Without Living Like a Pauper or Winning the Lottery) Updated and Revised by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Cover of the book Cisco DCUCI Quick Reference by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy