 |
|
|
Item Details
| Title:
|
MICROSOFT SQL SERVER 2012 HIGH-PERFORMANCE T-SQL USING WINDOW FUNCTIONS
|
| By: |
Itzik Ben-Gan |
| Format: |
Paperback |
| List price:
|
£27.49 |
|
We currently do not stock this item, please contact the publisher directly for
further information.
|
|
|
|
|
|
| ISBN 10: |
0735658366 |
| ISBN 13: |
9780735658363 |
| Publisher: |
MICROSOFT PRESS,U.S. |
| Pub. date: |
15 April, 2012 |
| Pages: |
244 |
| Description: |
Get a detailed look into the practical applications of window functions in Transact-SQL - the database programming language built into Microsoft SQL Server. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to perform calculations against sets of rows in your database - in a flexible, clear, and efficient manner. |
| 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 |
| Illustrations: |
Illustrations |
| Publication: |
US |
| Imprint: |
Microsoft Press,U.S. |
| Returns: |
Returnable |
|
|
|
 |
|
|
|
|
|
Little Worried Caterpillar (PB)
Little Green knows she''s about to make a big change - transformingfrom a caterpillar into a beautiful butterfly. Everyone is VERYexcited! But Little Green is VERY worried. What if being a butterflyisn''t as brilliant as everyone says?Join Little Green as she finds her own path ... with just a littlehelp from her friends.
|
|
All the Things We Carry PB
What can you carry?A pebble? A teddy? A bright red balloon? A painting you''ve made?A hope or a dream?This gorgeous, reassuring picture book celebrates all the preciousthings we can carry, from toys and treasures to love and hope. With comforting rhymes and fabulous illustrations, this is a warmhug of a picture book.
|
|
|
|