Close
Enter your search into one or more of the boxes below:
You can refine your search by selecting from any of the options below:
Search
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
Foyalty 83

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Paperback)

£27.49
To Order. Estimated despatch in 3-5 weeks.
Email me when back in stock

Synopsis

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

Computing & ITComputer programming / software developmentDatabase programmingComputing & ITDatabasesData miningComputing & ITDatabasesDatabase softwareSQL Server / MS SQL Publisher: Microsoft Press,U.S. Publication Date: 15/04/2012 ISBN-13: 9780735658363  Details: Type: Paperback Format: Books
Availability: To Order. Estimated despatch in 3-5 weeks.  

Itzik Ben-Gan is a principal mentor and a founder of SolidQ. A Microsoft MVP for SQL Server since 1999, Itzik teaches and consults internationally on T-SQL querying, programming, and query tuning. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.

More books by Itzik Ben-Gan

Leave Review

Delivery

Delivery Options

All delivery times quoted are the average, and cannot be guaranteed. These should be added to the availability message time, to determine when the goods will arrive. During checkout we will give you a cumulative estimated date for delivery.

Location 1st Book Each additional book Average Delivery Time
UK Standard Delivery FREE FREE 3-5 Days
UK First Class £4.50 £1.00 1-2 Days
UK Courier £7.00 £1.00 1-2 Days
Western Europe** Courier £17.00 £3.00 2-3 Days
Western Europe** Airmail £5.00 £1.50 4-14 Days
USA / Canada Courier £20.00 £3.00 2-4 Days
USA / Canada Airmail £7.00 £3.00 4-14 Days
Rest of World Courier £22.50 £3.00 3-6 Days
Rest of World Airmail £8.00 £3.00 7-21 Days

** Includes Austria, Belgium, Denmark, France, Germany, Greece, Iceland, Irish Republic, Italy, Luxembourg, Netherlands, Portugal, Spain, Sweden and Switzerland.

Delivery Help & FAQs

Returns Information

If you are not completely satisfied with your purchase*, you may return it to us in its original condition with in 30 days of receiving your delivery or collection notification email for a refund. Except for damaged items or delivery issues the cost of return postage is borne by the buyer. Your statutory rights are not affected.

* For Exclusions and terms on damaged or delivery issues see Returns Help & FAQs

You might also like

Practical Sql: A Beginner's Guide to...
(Paperback)
Anthony Debarros
 
 
£33.99
 
SQL Server 2017 Administration Inside...
(Paperback)
William Assaf; Randolph West; Sven...
 
 
£36.99
 
XML and JSON Recipes for SQL Server: ...
(Paperback)
Alex Grinberg
 
 
£24.99
 
Exam Ref 70-765 Provisioning SQL...
(Paperback)
Kurt Dillard; Christopher Ford
 
 
£31.99
 
© W&G Foyle Ltd
Foyles uses cookies to help ensure your experience on our site is the best possible. Click here if you’d like to find out more about the types of cookies we use.
Accept and Close