Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

Nonfiction, Computers, Database Management
Cover of the book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan, 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 ISBN: 9780735672543
Publisher: Pearson Education Publication: April 15, 2012
Imprint: Microsoft Press Language: English
Author: Itzik Ben-Gan
ISBN: 9780735672543
Publisher: Pearson Education
Publication: April 15, 2012
Imprint: Microsoft Press
Language: English

Apply powerful window functions in T-SQL—and increase the performance and speed of your queries

Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.

Discover how to:

  • Go beyond traditional query approaches to express set calculations more efficiently
  • Delve into ordered set functions such as rank, distribution, and offset
  • Implement hypothetical set and inverse distribution functions in standard SQL
  • Use strategies for improving sequencing, paging, filtering, and pivoting
  • Increase query speed using partitioning, ordering, and coverage indexing
  • Apply new optimization iterators such as Window Spool
  • Handle common issues such as running totals, intervals, medians, and gaps
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Apply powerful window functions in T-SQL—and increase the performance and speed of your queries

Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.

Discover how to:

More books from Pearson Education

Cover of the book Apple Pro Training Series by Itzik Ben-Gan
Cover of the book 3ds Max in 24 Hours, Sams Teach Yourself by Itzik Ben-Gan
Cover of the book Taming your Photo Library with Adobe Lightroom by Itzik Ben-Gan
Cover of the book Key Tools for Human Resource Management (Collection) by Itzik Ben-Gan
Cover of the book The Project Manager by Itzik Ben-Gan
Cover of the book Start Here! Build Windows 8 Apps with HTML5 and JavaScript by Itzik Ben-Gan
Cover of the book Statistical Analysis: Microsoft Excel 2010 by Itzik Ben-Gan
Cover of the book Ubiquitous Computing at Dai Nippon Magitti by Itzik Ben-Gan
Cover of the book Visual Stories: Behind the Lens with Vincent Laforet by Itzik Ben-Gan
Cover of the book Microsoft System Center Enterprise Suite Unleashed by Itzik Ben-Gan
Cover of the book Integrating and Extending BIRT by Itzik Ben-Gan
Cover of the book Presentation Zen by Itzik Ben-Gan
Cover of the book Understanding Big Data Scalability by Itzik Ben-Gan
Cover of the book Microsoft Exchange Server 2013 Pocket Consultant Databases, Services, & Management by Itzik Ben-Gan
Cover of the book Improving Preparedness in Supply Chain Risk Management at Jacket by Itzik Ben-Gan
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