Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Anglais) Broché – 15 avril 2012
Découvrez notre boutique Rentrée scolaire et universitaire : livres, agendas, fournitures, ordinateurs, ameublement...
|Neuf à partir de||Occasion à partir de|
- Choisissez parmi 17 000 points de collecte en France
- Les membres du programme Amazon Prime bénéficient de livraison gratuites illimitées
- Trouvez votre point de collecte et ajoutez-le à votre carnet d’adresses
- Sélectionnez cette adresse lors de votre commande
Les clients ayant acheté cet article ont également acheté
Description du produit
Présentation de l'éditeur
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
Biographie de l'auteur
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.
Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.
Pour obtenir l'appli gratuite, saisissez votre numéro de téléphone mobile.
Détails sur le produit
Si vous vendez ce produit, souhaitez-vous suggérer des mises à jour par l'intermédiaire du support vendeur ?
Commentaires client les plus utiles sur Amazon.com
Instead, it is focused and concise (200+ pages). And extremely well-written, by someone who clearly takes his teaching role seriously. Beyond just describing how to use the window functions, it does a great job of delving into the background needed to really understand how & why they work as they do.
In addition to describing SQL Server 2012 support for window functions, the book also details those areas in which full support for standard SQL window functions has not yet been implemented in SQL Server. It also suggests improvements that could be made to both the standard and to MS SQL.
Whenever possible, the book gives alternative queries constructed without the use of window functions. This is great as both a learning tool, and to convince you that in general you don't really want to go that route (non-window) if at all possible.
If you want to learn both the subtleties and quotidian uses of SQL window functions, get this book. Your brain will light up with new possibilities.
(If it helps credibility-wise, check out my mostly negative review of the same author's "Inside Microsoft SQL Server 2005: T-SQL Programming"--I am the proud holder of the "Most Helpful Critical Review" honor for that title. Ben-Gan's lucidity has increased considerably with this current effort.)
For now i will give this 5 stars but I still think it could be made simpler and more practical for us 'regular' users. I will say the accuracy of the book and samples seems pretty good so far which is nice since it can be annoying when you run into samples you are trying to learn from that don't work in some articles by other authors I have read. This authors material and books seem very accurate.
I wonder if regular expressions would be useful with these functions?