SQL Server Query Performance Tuning und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr
EUR 48,10
  • Alle Preisangaben inkl. MwSt.
Auf Lager.
Verkauf und Versand durch Amazon.
Geschenkverpackung verfügbar.
Menge:1
SQL Server Query Performa... ist in Ihrem Einkaufwagen hinzugefügt worden
Ihren Artikel jetzt
eintauschen und
EUR 20,50 Gutschein erhalten.
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Anhören Wird wiedergegeben... Angehalten   Sie hören eine Probe der Audible-Audioausgabe.
Weitere Informationen
Alle 2 Bilder anzeigen

SQL Server Query Performance Tuning (Englisch) Taschenbuch – 17. September 2014


Alle 2 Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Amazon-Preis Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
Taschenbuch
"Bitte wiederholen"
EUR 48,10
EUR 44,24 EUR 43,81
28 neu ab EUR 44,24 4 gebraucht ab EUR 43,81

Wird oft zusammen gekauft

SQL Server Query Performance Tuning + Microsoft SQL Server 2012 Internals
Preis für beide: EUR 87,05

Die ausgewählten Artikel zusammen kaufen
Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.


Produktinformation


Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Über den Autor und weitere Mitwirkende

Sajal Dam holds a master's of technology degree in computer science from the Indian Institute of Science, Bangalore, and has been working with Microsoft technologies for over 12 years. He has developed an extensive background in designing database applications and managing software development. Sajal also possesses significant experience in troubleshooting and optimizing the performance of Microsoft-based applications, from front-end web pages to back-end databases. While working at Microsoft, Sajal helped many Fortune 500 companies design scalable database solutions and maximize the performance of their database environments. As an IT strategist at Dell, Sajal manages Dell's vast database infrastructure by optimizing not only the databases, but also the database management processes, tools, and use of best practices. He also works closely with the application development teams and vendors, including Microsoft, in analyzing and resolving performance bottlenecks.

In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis
Hier reinlesen und suchen:

Kundenrezensionen

Es gibt noch keine Kundenrezensionen auf Amazon.de
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Sterne

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: 3 Rezensionen
3 von 3 Kunden fanden die folgende Rezension hilfreich
I bought the original edition of this book and loved it so I was curious to see how it ... 20. November 2014
Von Roger Wolter - Veröffentlicht auf Amazon.com
Format: Kindle Edition Verifizierter Kauf
I bought the original edition of this book and loved it so I was curious to see how it had evolved in this edition. It was well worth the investment to get the latest edition. Not only are the new features in SQL Server 2014 like In Memory optimization and clustered column store indexes lucidly explained but the original material on reading query plans, analyzing waits, setting server options, etc. has been rewritten and expanded. I got the Kindle edition which is more difficult to thumb through when you need to find something but much easier to take with me on airplanes. I highly recommend this - even if you already own a previous edition
1 von 1 Kunden fanden die folgende Rezension hilfreich
A very good, wide-ranging , SQL code optimization book. 23. Oktober 2014
Von Ian Stirk - Veröffentlicht auf Amazon.com
Format: Taschenbuch
Hi,

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.

A popular performance tuning book gets updated for SQL Server 2014, how does it fare?

This well-liked SQL Server book examines performance from various angles, but concentrates on improvements related to the SQL code itself. The book has been updated for SQL Server 2014, additionally various chapters have been restructured. The book is aimed at anyone responsible for SQL Server performance, especially DBAs and developers.

Below is a chapter-by-chapter exploration of the topics covered.

Chapter 1 SQL Query Performance Tuning
This chapter opens with a discussion of the performance tuning process steps i.e. identify bottlenecks, prioritize issues, troubleshoot issues, apply resolutions, quantify change, and repeat. The price of any performance improvement is examined in terms of targets and having a good-enough solution. The importance of having a baseline is introduced early, allowing you to determine if current processing is ‘normal’.

Performance problems can be due to a variety of causes, including problems with hardware, operating system, network, database design and SQL code. Most problems are due to poor SQL code. The author discusses the major performance killers in outline here, and expands on them in the remainder of the book. Problems examined include:
• Insufficient indexing
• Inaccurate statistics
• Improper query design
• Poorly generated execution plans
• Excessive blocking and deadlocks
• Non-set-based operations, usually T-SQL cursors
• Inappropriate database design
• Excessive fragmentation
In many ways this chapter is a summary of the rest of the book. It provides a good overview of the performance tuning process, including a helpful flowchart. There’s a useful overview of the major causes of bad performance, each of which is expanded upon in subsequent chapters. There are good links to related chapters in the book.
.
.
.
Conclusion
This book covers a wide range of performance topics and techniques, with the central aim of improving the performance of your SQL workload. It is generally easy to read, with practical step-by-step walkthroughs, helpful links between chapters, and good use of screenshots. Typically, code is provided to back up the assertions made. The book should take your level of expertise from level 3 to level 8 (based on a 1 to 10 scale).

While this book covers the majority of code-based performance topics, there were times when I wanted more detail. There was no mention of the more advanced performance tools like SQLDIAG or SQL Nexus. Sometimes the structure of the book felt awkward e.g. perfMon is explained in the memory chapter but its example usage is given in a later chapter. Having a separate detailed tools chapter, that is repeatedly referenced, may have been better.

This book is very similar to the 2012 edition of the book; while the screenshots have been updated for 2014, the text is perhaps 80% the same or similar. Although written for SQL Server 2014, much is applicable to 2012 and 2008. If you want a good, wide ranging, SQL code optimization book, I can certainly recommend this book.
1 von 6 Kunden fanden die folgende Rezension hilfreich
but have never seen one like this. I realize that I'm older (I said ... 16. November 2014
Von SLL - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
This review is only for the paperback version. While I realize that the book is already 564 pages long, the type font and line spacing are too small. It actually gives me a headache to read. I own dozens of programming books, but have never seen one like this. I realize that I'm older (I said old-er, not old), and some of this is my issue, but I had no choice but to return the book.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.