et plus d'un million d'autres livres sont disponibles pour le Kindle d'Amazon. En savoir plus

Identifiez-vous pour activer la commande 1-Click.
en essayant gratuitement Amazon Premium pendant 30 jours. Votre inscription aura lieu lors du passage de la commande. En savoir plus.
Amazon Rachète votre article
Recevez un chèque-cadeau de EUR 5,99
Amazon Rachète cet article
Plus de choix
Vous l'avez déjà ? Vendez votre exemplaire ici
Désolé, cet article n'est pas disponible en
Image non disponible pour la
couleur :
Image non disponible

Commencez à lire Microsoft SQL Server 2012 High-Performance T-SQL Using Wi... sur votre Kindle en moins d'une minute.

Vous n'avez pas encore de Kindle ? Achetez-le ici ou téléchargez une application de lecture gratuite.

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions [Anglais] [Broché]

Itzik Ben-Gan

Prix : EUR 20,60 Livraison à EUR 0,01 En savoir plus.
  Tous les prix incluent la TVA
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Il ne reste plus que 1 exemplaire(s) en stock (d'autres exemplaires sont en cours d'acheminement).
Expédié et vendu par Amazon. Emballage cadeau disponible.
Voulez-vous le faire livrer le jeudi 23 octobre ? Choisissez la livraison en 1 jour ouvré sur votre bon de commande. En savoir plus.


Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle EUR 14,41  
Broché EUR 20,60  
Vendez cet article - Prix de rachat jusqu'à EUR 5,99
Vendez Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions contre un chèque-cadeau d'une valeur pouvant aller jusqu'à EUR 5,99, que vous pourrez ensuite utiliser sur tout le site Les valeurs de rachat peuvent varier (voir les critères d'éligibilité des produits). En savoir plus sur notre programme de reprise Amazon Rachète.

Description de l'ouvrage

15 avril 2012

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

Offres spéciales et liens associés

Produits fréquemment achetés ensemble

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions + Microsoft SQL Server 2012 T-SQL Fundamentals + Microsoft SQL Server 2012 Internals
Acheter les articles sélectionnés ensemble

Descriptions du produit

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.

Détails sur le produit

En savoir plus sur l'auteur

Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.

Commentaires en ligne

Il n'y a pas encore de commentaires clients sur
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles
Commentaires client les plus utiles sur (beta) 4.3 étoiles sur 5  12 commentaires
20 internautes sur 20 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 A good book 26 mai 2012
Par Dr. Robotnik - Publié sur
Format:Broché|Achat vérifié
This book is a refreshing alternative to the usual 900 page everything-and-the-kitchen sink tomes that seem to dominate this genre.

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.)
12 internautes sur 13 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Good One for Specific Requirement 20 août 2012
Par SQL Learner - Publié sur
One of the good "Cheat" book I came across. Yes, I agree with many that there is no doubt Itzik Ben-Gan is one of the great T-SQL experts in the industry. Initially I thought many of the functions he described cannot be used in OLTP model. Very quickly I realized I was wrong to some extent, I had to identify duplicate entries and Islands and the queries were right there. But I think I will stick to my Original Comment - the book is very specific for certain window function as the title suggests which are - ranking, distribution, ordering, getting ranges, gaps, island, duplicates, running totals, packing intervals, aggregates and finally optimizing them. Ofcourse that's what the title suggest (Window Functions..) and is very well concised in 200 odd pages when compared to 900 or so in other books. Actually I was expecting - to know different alternatives for creating such functions, which I did not find much. There is a mention of CLR, but one should be good with .NET coding. My final conclusion would be go for the book in case you have to deal a lot with analytical type of coding. This is the book, where we can simply use the proven logic.
4 internautes sur 5 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Another excellent book by Itzik Ben-Gan and SQM 4 juin 2012
Par John - Publié sur
Worth every penny. Every chapter is packed with new tools for your toolbox. I am wrapping up a project that would not have been possible without these window functions.
1 internautes sur 1 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Good Information 13 février 2014
Par T. Copling - Publié sur
Format:Format Kindle|Achat vérifié
The book started off great explaining Window Functions; however I felt that there were certain parts that the author could have left out. For example, he went over some functionality that wasn't available in SQL SERVER; where I was hoping he would focus primarily with what was currently available. Overall, it's a good book; I'm definitely going to have to read it again.
1 internautes sur 1 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Help in a True Understanding of SQL Windows Functions (at least as far as I can) 11 novembre 2012
Par John R. Spencer - Publié sur
Format:Broché|Achat vérifié
The book has proven invaluable on the job in a current project.
I had used 'window' functions in the past; however, I truly did not have a real understanding of what 'result set' I was working with. And, as correctly stated, performance was 'blazing' now that the use of a 'window' function is known to be using the current result set. While probably not a 'nugget' for SQL experts, just realizing that proved a real 'tip'...

I have used other books by the author and found his instructional style quite pleasing to deal with considering the 'complexity' of how one 'should' think when dealing with SQL.
Ces commentaires ont-ils été utiles ?   Dites-le-nous

Discussions entre clients

Le forum concernant ce produit
Discussion Réponses Message le plus récent
Pas de discussions pour l'instant

Posez des questions, partagez votre opinion, gagnez en compréhension
Démarrer une nouvelle discussion
Première publication:
Aller s'identifier

Rechercher parmi les discussions des clients
Rechercher dans toutes les discussions Amazon

Rechercher des articles similaires par rubrique


Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?