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 What Makes People Listen to Your Presentation by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Microsoft Office 2007 for Windows by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Cloud Computing by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Panasonic Lumix GX7 and GM1 by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Modeling Techniques in Predictive Analytics with Python and R by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Upgrading and Repairing PCs by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Sams Teach Yourself Android Application Development in 24 Hours by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Creating a Digital Home Entertainment System with Windows Media Center by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Life Balance Is Fiction by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Network Functions Virtualization (NFV) with a Touch of SDN by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Test-Driven Database Development by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book CCENT/CCNA ICND1 100-105 Official Cert Guide by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Level 2: Gandhi by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Canon EOS 7D Mark II by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book How to Be an Entrepreneur 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