• Tous les prix incluent la TVA.
Temporairement en rupture de stock.
Commandez maintenant et nous vous livrerons cet article lorsqu'il sera disponible. Nous vous enverrons un e-mail avec une date d'estimation de livraison dès que nous aurons plus d'informations. Cet article ne vous sera facturé qu'au moment de son expédition.
Expédié et vendu par Amazon.
Emballage cadeau disponible.
Quantité :1
Inside Microsoft® SQL... a été ajouté à votre Panier
+ EUR 2,99 (livraison)
D'occasion: Bon | Détails
Vendu par Britbooksfr
État: D'occasion: Bon
Commentaire: Simplement Brit: Nous avons envoyé dans nos livres d'entrepôts britanniques du bon état de plus de 1 million de clients satisfaits à travers le monde. nous nous engageons à vous fournir un service fiable et efficace à tout moment.
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 cette image

Inside Microsoft® SQL Server(TM) 2005: T-SQL Querying (Anglais) Broché – 26 avril 2006


Voir les formats et éditions Masquer les autres formats et éditions
Prix Amazon Neuf à partir de Occasion à partir de
Broché
"Veuillez réessayer"
EUR 43,77
EUR 20,00 EUR 4,16

Il y a une édition plus récente de cet article:

T-SQL Querying
EUR 51,79
En stock.
EUR 43,77 Livraison à EUR 0,01. Temporairement en rupture de stock. Commandez maintenant et nous vous livrerons cet article lorsqu'il sera disponible. Nous vous enverrons un e-mail avec une date d'estimation de livraison dès que nous aurons plus d'informations. Cet article ne vous sera facturé qu'au moment de son expédition. Expédié et vendu par Amazon. Emballage cadeau disponible.

Descriptions du produit

Biographie de l'auteur

Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.



Détails sur le produit


En savoir plus sur les auteurs

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

Dans ce livre (En savoir plus)
Parcourir les pages échantillon
Couverture | Copyright | Table des matières | Extrait | Index | Quatrième de couverture
Rechercher dans ce livre:

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: 35 commentaires
48 internautes sur 51 ont trouvé ce commentaire utile 
Must Have 20 décembre 2006
Par Grant Fritchey - Publié sur Amazon.com
Format: Broché
This will be a standard book on most DBA's desktops. Itzik Ben-Gan of Solid Quality Learning has taken the Advanced T-SQL course that he teaches and turned it into a fantastic book.

The first two chapters cover the logic of query processing and what physically occurs when you run a query. Very early on Itzik establishes a practice of defining a problem or a question about T-SQL and then spends time working through the solution. This approach carries through the entire book. This not only allows the user to see the problem solving approach in action, but enables the user in pursuing the solutions themselves. Itzik takes the time to lay out a very detailed methodology for identifying and tuning problem queries from the server, through the database, down to the query that's causing the problems. From these foundation chapters he explores topics such as Subqueries and Table Expressions, Joins and Set Operations, Aggregating and Pivoting Data, Top and Apply, Data Modification and finally Graphs, Hierarchies and Recursive Queries.

The greatest thing about the book is that Itzik really explores his solutions. He walks the user into a mind set that accepts only set based operations as the norm for data access. He shows multiple solutions to many of the problems and outlines where and how those solutions differ. This book acts as a good mechanism for actually learning the details of how to use T-SQL withing SQL Server 2005. He also points out where there are differences from 2000 and supplies 2000 only solutions to a lot of the problems, which can help those that need to maintain two code bases. He regularly uses and addresses 2005 functionality so there is zero indications of this being a 2000 book warmed over for re-publication.

Make no mistakes here. This is a high-end book. If you're just getting started in T-SQL, you may want to start out somewhere else. If, after getting down the concepts of SELECT.. FROM... WHERE... GROUP BY... ORDER BY, etc., then come back here and learn what happens and the right reasons to do the right things with the scripts that you write.

I work primarily as a database developer, doing database design from logical models and business requirements and then developing stored procedures, etc., for accessing data from those databases. This kind of information is absolutely vital to doing the best job I can. I think I was predisposed to like this work, but I've actually been picking it up during the day to refer back to points that were unclear to me or that I want to better communicate to others, especially from the first two chapters.
22 internautes sur 23 ont trouvé ce commentaire utile 
An essential read for serious T-SQL developers 26 novembre 2006
Par Adam Machanic - Publié sur Amazon.com
Format: Broché
As someone quite familiar with Itzik Ben-Gan's work, I expected this to be a really good book. But since I've been reading about and working with SQL Server 2005 since early betas, I didn't expect to learn much. I was, as it turned out, wrong on both counts.

This book surpassed all of my expectations. It's more than just a really good book -- it's a great book -- and I learned quite a bit from reading it. Itzik and his co-authors have a knack for explaining every idea, down to the minute details that you might miss in other books or documentation. The examples are clear and precise, and the author team has done a great job of making even complex topics crystal clear.

This is certainly not a book for beginners; intermediate and advanced practitioners will want to use this book to help get more out of SQL Server. Learn the basics of T-SQL and SQL Server before tackling this one if you want to take full advantage of what it has to offer.
11 internautes sur 11 ont trouvé ce commentaire utile 
The true SQL 2005 Book!!! 22 février 2007
Par Stephen - Publié sur Amazon.com
Format: Broché
I strongly recommend this book to anyone wanting a better understanding of SQL server 2005. I have read several books in this series, they are all good, but this is the best by far. It starts by discussing the logical processing of query, which is very important for understand how to write effective queries. It then discusses how to evaluate your queries, it discusses indexes in extensive detail - to the point that you will understand how to they work and how to make effective indexes. It explains many of the new T-SQL features, and how to use them in real life scenarios. However, note that this is not a T-SQL reference guide. Books online serves that purpose. This is a MUST HAVE for my team.
12 internautes sur 13 ont trouvé ce commentaire utile 
Pedantic 20 septembre 2007
Par Jaewoo Kim - Publié sur Amazon.com
Format: Broché Achat vérifié
The MS SQL books have dramatically risen in quality in a few short years. When SQL 7 and 2000 were released, there were may be 1-3 book which were truly outstanding. For SQL 2005, however, there are at least 5-10 books which are truly worthwhile and this is one of them.

The reason why the quality of books has risen is the expertise of the authors. For this book, the authors are either MS SQL MVP or have been involved with the creation of MS SQL at Microsoft.

Generally speaking, the book has high level expert description of the underlying MS SQL 2005 architecture and T-SQL commands. But it lacks a nice flowing writing style which hempers the understanding to a willing reader. This book is an another example of authors who are inept at explaining the subject matter which they are an expert much like a professor who can't teach.

I also felt some parts of the book were sloppy or not as detailed. For example, the authors state that one of the steps of T-SQL query tuning is the need to correlate wait stats with problematic queries. Yet they never provide an adequate example (other than providing a useless query of SYS.DM_OS_PERFORMANCE_COUNTERS table) of how to connect wait stat with a specific transaction. This is a huge missing link.

PROS:
1)Awesome details on Indexes and Query plans
2)Solid advice on how to improve T-SQL for better performance.

Cons:
1)Not for the beginners. The book goes straight to the harder subjects (PIVOT, APPLY, complex joins etc).
2)Does not cover simple or fundamental subject matters.
20 internautes sur 24 ont trouvé ce commentaire utile 
Useful but COULD be much better. Needs major editorial intervention. 26 juillet 2007
Par Malleus Maleficarum - Publié sur Amazon.com
Format: Broché
Real quick:

1. Target reader: someone with a good grasp of the 2000 Server wishing to learn the new stuff that came with the 2005 server (there's a lot: the 2005 product is _much_ better than the previous). This is probably the only thing that's unequivocally good about this book.

2. Content: Mostly about tables (joins, logical operations, physical operations, aggregates, a bit of esoterica -- puzzles, hierarchies, stuff like that, just a bit at the end). No CLR to speak of in this volume (there's a tiny bit in the secton on user-defined aggregates; much more of it in the other volume, Programming). This book _should_ be considered the first volume of the two-volume set. If you get this one, you'll get the other one too; neither tome is self-sufficient; in fact there's a lot of explicit interdependence.

3. Very clean technically: technical editing very good (no typos either).

4. Depth vs breadth: the book is more extensive than deep. Some people here say it's difficult -- and it is true, which unfortunately brings me to the next point:

5. Writing: ABHORRENT. That's why it seems difficult -- and it very much is, except it's not due to any kind of inherent difficulty of the subject matter. It's the authors' complete, laughable inability to use the English language to explain things that makes reading this book such a chore. There is also conceptual muddle (people write as they think).

Now, experience taught me to forgive literary incapacity to a _technical_ author (to a degree; and I do take notice and, if possible, avoid him in the future). In cases like that I put the blame squarely on the publisher, especially if otherwise I know the publisher to be solid. The book's front matter lists Roger Leblanc as the copy editor of this book: Roger Leblanc, you get an F; as a man of honour you gotta kill yourself now. The book is full of unimaginable, fantastic garbage of every possible kind, from a massive amount of grating usage errors to a pervasive lack of unity, coherence, and logical connectedness on the page/paragraph level, to a frequent lack of the overall unity: it's clear that an editor never touched it. When I bought this book and read the first chapter I was so p-off I almost sent it back (I got as far as getting an RMA from Amazon). I did keep it though.

Do I recommend this book? It has been useful to me, so -- with great reservation, and only to the right reader -- yes, kinda. And please check out what else is available (there's tons of books on the 2005 server these days). The Querying book is part of the three-volume update and extension of the server-2000 version by Delaney. Delaney's server-2000 book was extremely useful and quite decently written. I wish they let her write the new version, even though it's now three moderately sized books instead of a single huge one, and it's probably difficult for one person to do it all.
Ces commentaires ont-ils été utiles ? Dites-le-nous


Commentaires

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