undrgrnd Cliquez ici Baby NEWNEEEW nav-sa-clothing-shoes Cloud Drive Photos FIFA16 cliquez_ici Rentrée scolaire Shop Fire HD 6 Shop Kindle Paperwhite cliquez_ici Jeux Vidéo Bijoux Montres Montres
et plus d'un million d'autres livres sont disponibles pour le Kindle d'Amazon. En savoir plus
EUR 22,46
  • Tous les prix incluent la TVA.
Il ne reste plus que 4 exemplaire(s) en stock (d'autres exemplaires sont en cours d'acheminement).
Expédié et vendu par Amazon.
Emballage cadeau disponible.
Quantité :1
Microsoft SQL Server 2012... a été ajouté à votre Panier
Amazon rachète votre
article EUR 7,03 en chèque-cadeau.
Vous l'avez déjà ?
Repliez vers l'arrière Repliez vers l'avant
Ecoutez Lecture en cours... Interrompu   Vous écoutez un extrait de l'édition audio Audible
En savoir plus
Voir les 2 images

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Anglais) Broché – 15 avril 2012

Voir les formats et éditions Masquer les autres formats et éditions
Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle
"Veuillez réessayer"
"Veuillez réessayer"
EUR 22,46
EUR 21,36 EUR 45,23

Livres anglais et étrangers
Lisez en version originale. Cliquez ici

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 Internals + Microsoft SQL Server 2012 T-SQL Fundamentals
Prix pour les trois: EUR 96,84

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.

Quels sont les autres articles que les clients achètent après avoir regardé cet article?

Commentaires en ligne

Il n'y a pas encore de commentaires clients sur Amazon.fr
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles

Commentaires client les plus utiles sur Amazon.com (beta)

Amazon.com: 16 commentaires
22 internautes sur 22 ont trouvé ce commentaire utile 
A good book 26 mai 2012
Par Dr. Robotnik - Publié sur Amazon.com
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.)
14 internautes sur 15 ont trouvé ce commentaire utile 
Good One for Specific Requirement 20 août 2012
Par SQL Learner - Publié sur Amazon.com
Format: Broché
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.
2 internautes sur 2 ont trouvé ce commentaire utile 
Worthwhile Subject 6 octobre 2012
Par HighTech - Publié sur Amazon.com
Format: Broché Achat vérifié
Since I actually used the sample chapters to solve a problem with updating all duplicate rows except the first duplicate in a set of duplicates I thought I should break down and buy the book. I consider it somewhat of a brain twister and will use this to further my query expertise. I am one of those DBA's that has so many instances to manage that I rarely ever get to do any coding for many years now. I am hoping this helps bring back some, and develope new, skills. I also decided to get the fundamentals book and will switch between the 2.
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?
2 internautes sur 2 ont trouvé ce commentaire utile 
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 Amazon.com
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.
4 internautes sur 5 ont trouvé ce commentaire utile 
Another excellent book by Itzik Ben-Gan and SQM 4 juin 2012
Par John - Publié sur Amazon.com
Format: Broché
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.
Ces commentaires ont-ils été utiles ? Dites-le-nous


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