SQL Server 2008 Query Performance Tuning Distilled et plus d'un million d'autres livres sont disponibles pour le Kindle d'Amazon. En savoir plus

Acheter neuf

ou
Identifiez-vous pour activer la commande 1-Click.
Acheter d'occasion
D'occasion - Très bon Voir les détails
Prix : EUR 24,55

ou
 
   
Amazon Rachète votre article
Recevez un chèque-cadeau de EUR 10,13
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 SQL Server 2008 Query Performance Tuning Distilled 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.

SQL Server 2008 Query Performance Tuning Distilled [Anglais] [Broché]

Grant Fritchey , Sajal Dam
4.0 étoiles sur 5  Voir tous les commentaires (1 commentaire client)
Prix : EUR 50,28 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
En stock.
Expédié et vendu par Amazon. Emballage cadeau disponible.

Formats

Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle EUR 23,65  
Broché EUR 50,28  
Broché --  
Vendez cet article - Prix de rachat jusqu'à EUR 10,13
Vendez SQL Server 2008 Query Performance Tuning Distilled contre un chèque-cadeau d'une valeur pouvant aller jusqu'à EUR 10,13, que vous pourrez ensuite utiliser sur tout le site Amazon.fr. 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.
Il y a une édition plus récente de cet article:
SQL Server 2012 Query Performance Tuning SQL Server 2012 Query Performance Tuning
EUR 56,49
En stock.

Offres spéciales et liens associés


Descriptions du produit

SQL Server 2008 Query Performance Tuning Distilled Presenting troubleshooting methods for identifying poorly performing stored procedures and queries, this reference isolates the causes of that poor performance and offers suggestions for fixing the underlying problems. Developers, database administrators, and any others who develop Transact-SQL queries will find this book an indispensable resource. Full description

Détails sur le produit

  • Broché: 600 pages
  • Editeur : APress; Édition : 1 (23 mars 2009)
  • Langue : Anglais
  • ISBN-10: 1430219025
  • ISBN-13: 978-1430219026
  • Dimensions du produit: 3,3 x 18,5 x 23 cm
  • Moyenne des commentaires client : 4.0 étoiles sur 5  Voir tous les commentaires (1 commentaire client)
  • Classement des meilleures ventes d'Amazon: 118.593 en Livres anglais et étrangers (Voir les 100 premiers en Livres anglais et étrangers)
  •  Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?


En savoir plus sur l'auteur

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
Rechercher dans ce livre:

Commentaires en ligne 

5 étoiles
0
3 étoiles
0
2 étoiles
0
1 étoiles
0
4.0 étoiles sur 5
4.0 étoiles sur 5
Commentaires client les plus utiles
Par Florent K
Format:Broché
Livre très utile pour optimiser SQL 2005+. Dommage que des cas complexes ne soient pas abordés. exemple la création des indexes pour une requête comprenant des jointures pour 4 à 8 tables.
Avez-vous trouvé ce commentaire utile ?
Commentaires client les plus utiles sur Amazon.com (beta)
Amazon.com: 4.7 étoiles sur 5  29 commentaires
40 internautes sur 41 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Fantastic for Performance Tuners 21 avril 2009
Par Brent Ozar - Publié sur Amazon.com
Format:Broché
My gauge of an amazing book is simple: if I've got a question, and I reach for the book BEFORE I search the web, then it's an amazing book.

Several times in the last two weeks, I reached for this book first.

Query performance tuning is the art of reading a query's execution plan, figuring out why it's not fast, and then determining the most cost-effective way to make it faster. Anybody can throw more indexes in and just hope it speeds up, but as the book illustrates, sometimes that can hurt more than help.

To do a good job, the tuner needs to know about indexing, statistics, execution plans, compilations, blocking, deadlocks, and query design issues that can force a query to perform poorly. Some of this stuff is covered in abstract terms in college classes, but for the most part, all of us - developers, DBAs, sysadmins - are pretty much unprepared to guess what's going on inside the SQL Server engine.

When you first design and deploy an application, that's a great thing: you don't need to know what's going on inside the black box. SQL Server handles a lot of load with the default settings, with pretty much any application design, before things start to creak and groan. I've seen people build amazingly big SQL Server applications without any knowledge of how indexes or execution plans work. When you start to run into performance problems, you need expert help fast - and that's what this book provides.

Regardless of your seniority level, you're going to find this book's price an extremely worthwhile investment. The book's authors, Grant Fritchey and Sajal Dam, strike a great balance between bringing you up to speed versus diving into advanced concepts. Chapter 4 on Index Analysis is a great example. It spends the first few pages bringing the beginners up to speed on what an index is and how B-trees work. Then it gradually layers on an explanation of how you would approach index design and why the width of your index matters. The explanation includes queries that prove the concepts, with screenshots of results where appropriate. The discussion ramps up to more advanced topics like covering indexes, filtered indexes, and compression.

I really like the organization of this book because it progresses in the same way that I'd recommend training for a performance tuner. If you need to make an application run faster, read the book in order. Don't be tempted to jump to, say, execution plan analysis - you'll make poor decisions without understanding the concepts discussed earlier.

I've been performance tuning applications for years, trying to wring every last dollar's worth out of my hardware to make our applications run faster, and I keep learning things as I go through this book. Normally, I try to read the entire book cover to cover before posting a review, but in this case, it's going to be quite a while before I finish the book. I just keep reading a chapter, catching enough things I didn't know before, and then stopping to apply that knowledge and test it out in my lab. I highly recommend it.
24 internautes sur 25 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 SQL Server 2008 Query Performance Tuning Distilled 5 mai 2009
Par -tg - Publié sur Amazon.com
Format:Broché|Achat vérifié
Great book. I've been waiting for the re-write to Sajal Dam's book on SQL Server 2000 performance tuning for a very long time. The only problem with it is that that too many example scripts do not match the code in the book. [case in point: On pg. 289 it references a script called stats_changes.sql. The code in the download is nothing like the code on pg. 290. Ditto for pg. 177 and several others.] This leaves the reader to figure it out for themself. The book includes an email address for the author that rejects all attempts to send him email and I see no updates to the download since it was first published. If these oversites are corrected, this would be a great learning resource for the SQL Server professional charged with performance tuning responsibilities.
9 internautes sur 9 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 A great reference book on SQL Tuning. 24 novembre 2009
Par Sudheer K. Maharana - Publié sur Amazon.com
Format:Broché
One of the finest book on SQL Server Perf Tuning. To be honest I used to have the SQL Server performance tuning book by Ken England on SQL 2000 and looking for it's sequel on 2005. I went to the book store and ordered the book but it was disappointing. Then this book was given to me by one of my friends. A great reference book as I was expecting. Lot of theories and matching examples make this book stand out from the rest. SQL Server is just not SQL Tuning. It includes Database System tuning. This book has given a dedicated chapter in making you understand the same. It gives you a perspective on how to approach to a performance tuning from identification of the performance bottleneck to troubleshooting the problem. I enjoyed reading chapters on indexing and Index, Statistics and Execution Cache Analysis. However, I wanted to see more detail on tuning XML and Service Broker.

I will suggest this book for other DBAs and SQL Programmers who want to know the theories behind Index and Statistics, BLocking and Deadlocking, Fragmentation.
5 internautes sur 5 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Performance Tuning actually distilled 21 décembre 2009
Par Rajkumar Ramasamy - Publié sur Amazon.com
Format:Broché
A very good reference book on SQL server performance tuning on diverse directions.

On the initial chapters, you can find a good introduction on Performance tuning, Performance analysis and on the Database Engine Tuning Advisor. There are various analysis and optimization techniques explained in later chapters. There is comprehensive information about most common performance issues that occurs due to Query designs and deadlocks.

We can find more information on tuning indexes like when and where to apply what type of index. Later, the workload optimization techniques explains ways to identify and research expensive queries and jobs and "What not" to do to avoid performance issues. This book helps not only to write individual queries without any performance flaws, it also helps to find where the flaws are in existing queries. I would like to mention that there are good of examples of queries (which everyone look for) which make the reader to understand where performance issues or bottlenecks occur and what to do with it.

One good sense I had when I started reading the book is it isn't that hard to read through the book even you are new to performance tuning in SQL server. I would strongly recommend this book for all database performance professionals (Even the beginners in Performance Tuning).
2 internautes sur 2 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 SQL Server DBA Rave Review 2 octobre 2010
Par Thomas Leblanc - Publié sur Amazon.com
Format:Broché|Achat vérifié
From a Simple-Talk article to eBook on Query Plans help create a great book from Grant Fritchey. I met Grant at SQL PASS in 2008 and then at SQLSaturday in New York, where he demonstrated addictive enthusiasm about SQL Server. I bought this book as soon as it went on sell. This was a missing piece of information for the SQL Server community until Grant and Sajal brought this book to the market. Please buy and read this book if you are a DBA or developer that has to tune queries in your job.

Thanks,
Thomas LeBlanc, MCDBA & MCITP
Ces commentaires ont-ils été utiles ?   Dites-le-nous
Rechercher des commentaires
Rechercher uniquement parmi les commentaires portant sur ce produit

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
Thème:
Première publication:
Aller s'identifier
 

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


Rechercher des articles similaires par rubrique


Commentaires

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