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 Getting Your Retirement Act Right by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book The Visual Toolbox by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Java Application Architecture by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book MCSA 70-741 Cert Guide by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Helping You Be a Leader by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Business Express: Your first 60 days as a leader by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Photographing Women by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book PHP, MySQL & JavaScript All in One, Sams Teach Yourself by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Cisco Voice over IP (CVOICE) (Authorized Self-Study Guide) by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Real-Time 3D Rendering with DirectX and HLSL by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Start Your New Job with Confidence by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book The Economics of Software Quality by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Mechatronics by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book Law Express: Employment Law by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Cover of the book My Samsung Galaxy S5 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