Industrial-Sized Deals Shop all Back to School Shop Men's Hightops Learn more nav_sap_SWP_6M_fly_beacon Iron Maiden $5 Off Fire TV Stick Off to College Essentials Shop Popular Services hog hog hog  Amazon Echo Starting at $99 Kindle Voyage Nintendo Digital Games Shop Back to School with Amazon Back to School with Amazon Outdoor Recreation Deal of the Day

SQL Server DMVs in Action: Better Queries with Dynamic Management Views 1st Edition

4 customer reviews
ISBN-13: 978-1935182733
ISBN-10: 1935182730
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $2.00
Learn More
Trade in now
Have one to sell? Sell on Amazon
Buy used
$29.27
Buy new
$57.97
More Buying Choices
23 New from $34.92 17 Used from $29.27
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Textbooks
$57.97 FREE Shipping. Only 14 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

SQL Server DMVs in Action: Better Queries with Dynamic Management Views + SQL Server MVP Deep Dives
Price for both: $93.59

Buy the selected items together

Editorial Reviews

About the Author

Ian Stirk is a freelance consultant based in London. He's a world-class expert in SQL Server performance and a fierce advocate for DMVs.

NO_CONTENT_IN_FEATURE


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Paperback: 375 pages
  • Publisher: Manning Publications; 1 edition (May 16, 2011)
  • Language: English
  • ISBN-10: 1935182730
  • ISBN-13: 978-1935182733
  • Product Dimensions: 7.4 x 0.7 x 9.2 inches
  • Shipping Weight: 1.4 pounds (View shipping rates and policies)
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Best Sellers Rank: #1,554,766 in Books (See Top 100 in Books)

More About the Author

My current skill base is largely centered on SQL Server, with specialties in performance and troubleshooting - this allows me to cover a diverse range of SQL Server subsystems. I've also written a well-received SQL Server performance book: SQL Server DMVs in Action.

In the course of my work I often create new software utilities, and author articles on these to share with others. Additionally, I'm a technical reviewer of books and magazines. I feel it is important to give something back to the industry that provides me with a living.

I'm interested in a wide range of other technologies, particularly Mobile, Big Data, Social Media, C#/.NET, and future trends. I've worked in IT since 1987, so covered a lot of ground: Mainframes, Minis, PCs, Internet, and coded in more than 15 different programming languages.

On a final note, I'm a freelance consultant, and I'm available to help improve the performance of your SQL Servers/C#. You can contact me for availability and cost at ian_stirk@yahoo.com.

Specialties:
* SQL Server Performance and troubleshooting
* SQL Server Consultancy
* .NET/C# Performance
* SQL Server/C# development

Customer Reviews

5 star
100%
4 star
0%
3 star
0%
2 star
0%
1 star
0%
See all 4 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

5 of 5 people found the following review helpful By Jose on August 12, 2011
Format: Paperback Verified Purchase
This book is fantastic. It is not my 1st DMV book, I actually own Performance Tuning with SQL Server Dynamic Management Views (High Performance Sql Server), but I consider this one a better book, without saying the other one is bad either. The reason for that is that this book has a better layout and it is easier to follow. The code snippets are more practical too, in my opinion. This book helped me to troubleshoot (and improve) several slow queries the same day I bought it.

What I prefer or like of this book is the layout and logic. It would make more sense if you read from start to end, but you can even jump into an specific chapter and start taking benefit from it. You will need a basic understanding of T-SQL, but the explanations are clear and easy to follow. It helps that they also show the screen-shoots of the query results and they even provide further explanation of the code snippet itself, like what line is doing what, the reason for using CROSS APPLY, etc.

DMVs are not new, they were 1st introduced on SQL2005 couple of years ago, but combine them via JOINS can be a very complex task. I've been creating my own code snippets for quite a while but these two books actually go beyond from giving you a simple code and they teach you something.

By the way, there is no Kindle version of this book at the time of my review, but when you buy the regular paper book, you later can download the ebook version on three different formats, and they are free: PDF, ePub and Mobi, that's a nice deal! I have my own hard copy at home, and downloaded the PDF version on my work's PC. Be aware that some of the code snippets are difficult to read on a Kindle 3 though, so better if you use an iPad of Kindle DXG for that.
Read more ›
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By Dmitry Didovicher on August 13, 2013
Format: Paperback
This is one of the BEST Books about SQL Server ever written. Goes beyond just DMV you get to understand some of the internals of SQL
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
Great book. Scripts alone make this a valuable resource.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 2 people found the following review helpful By bob on July 20, 2011
Format: Paperback Verified Purchase
This is an excellent book for getting up to speed with SQL Server Dynamic Management Views. This book is a very valuable reference.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
SQL Server DMVs in Action: Better Queries with Dynamic Management Views
This item: SQL Server DMVs in Action: Better Queries with Dynamic Management Views
Price: $57.97
Ships from and sold by Amazon.com

What Other Items Do Customers Buy After Viewing This Item?

Want to discover more products? Check out this page to see more: c++