Inside Microsoft SQL Server 2008 T-SQL Querying

Nonfiction, Computers, Database Management
Cover of the book Inside Microsoft SQL Server 2008 T-SQL Querying by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass, 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, Lubor Kollar, Dejan Sarka, Steve Kass ISBN: 9780735638303
Publisher: Pearson Education Publication: March 25, 2009
Imprint: Microsoft Press Language: English
Author: Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
ISBN: 9780735638303
Publisher: Pearson Education
Publication: March 25, 2009
Imprint: Microsoft Press
Language: English

Tackle 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 advanced techniques to optimize your code’s performance.

Discover how to:

  • Move from procedural programming to the language of sets and logic
  • Optimize query tuning with a top-down methodology
  • Assess algorithmic complexity to predict performance
  • Compare data-aggregation techniques, including new grouping sets
  • Manage data modification—insert, delete, update, merge—for performance
  • Write more efficient queries against partitioned tables
  • Work with graphs, trees, hierarchies, and recursive queries
  • Plus—Use pure-logic puzzles to sharpen your problem-solving skills
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Tackle 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 advanced techniques to optimize your code’s performance.

Discover how to:

More books from Pearson Education

Cover of the book The Truth About Identity Theft by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Microsoft Exchange Server 2007 Unleashed by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Certified Ethical Hacker (CEH) Cert Guide by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Sams Teach Yourself SQL Server 2005 Express in 24 Hours by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book My Office 2016 for Mac (includes Content Update Program) by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Confidence by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book QuickBooks 2014 on Demand by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Adobe Photoshop Elements 4 by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book How to Write a Successful Cover Letter, Not One That Sinks You by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Training Guide Programming in HTML5 with JavaScript and CSS3 (MCSD) by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book The Truth About Search Engine Optimization by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Digital Alchemy by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book How to Influence and Persuade 2nd edn by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Building Open Source Hardware by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book A Practical Guide to Fedora and Red Hat Enterprise Linux by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
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