or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
37 used & new from £12.28

Have one to sell? Sell yours here
 
   
Inside Microsoft SQL Server 2005: Query Tuning & Optimization: Query Tuning and Optimization
 
 

Inside Microsoft SQL Server 2005: Query Tuning & Optimization: Query Tuning and Optimization (Paperback)

by S. Agarwal, C. Freedman, A. Machanic, R. Talmage Kalen Delaney (Author)
4.0 out of 5 stars  See all reviews (1 customer review)
RRP: £39.49
Price: £25.17 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £14.32 (36%)
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
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 3 left in stock--order soon (more on the way).

Want guaranteed delivery by Tuesday, November 10? Choose Express delivery at checkout. See Details
32 new from £12.28 5 used from £34.20

Frequently Bought Together

Inside Microsoft SQL Server 2005: Query Tuning & Optimization: Query Tuning and Optimization + Inside SQL Server 2005: The Storage Engine (Solid Quality Learning) + Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)
Price For All Three: £70.86

Some of these items ship sooner than the others. Show details


Customers Who Bought This Item Also Bought

Inside SQL Server 2005: The Storage Engine (Solid Quality Learning)

Inside SQL Server 2005: The Storage Engine (Solid Quality Learning)

by Kalen Delaney (Solid Quality Learning)
4.7 out of 5 stars (3)  £22.34
Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)

Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)

by Lubor Kollar, Dejan Sarka Itzik Ben-Gan (Solid Quality Learning)
4.9 out of 5 stars (11)  £23.35
Inside SQL Server 2005: T-SQL Programming (Solid Quality Learning)

Inside SQL Server 2005: T-SQL Programming (Solid Quality Learning)

by Dejan Sarka; Roger Wolter Itzik Ben-Gan (Solid Quality Learning)
5.0 out of 5 stars (2)  £20.58
SQL Server 2005 Reporting Services Step by Step Book/CD Package (Step by Step (Microsoft))

SQL Server 2005 Reporting Services Step by Step Book/CD Package (Step by Step (Microsoft))

by Stacia Misner; Hitachi Consulting
3.0 out of 5 stars (1)  £20.29
SQL Server 2005 Analysis Services Step by Step Book/CD Package (Step by Step (Microsoft))

SQL Server 2005 Analysis Services Step by Step Book/CD Package (Step by Step (Microsoft))

by Reed Jacobson; Stacia Misner; Hitachi Consulting
3.7 out of 5 stars (3)  £18.02
Explore similar items

Product details

  • Paperback: 448 pages
  • Publisher: MICROSOFT PRESS (2 Oct 2007)
  • Language English
  • ISBN-10: 0735621969
  • ISBN-13: 978-0735621961
  • Product Dimensions: 22.9 x 18.3 x 3.8 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon.co.uk Sales Rank: 128,425 in Books (See Bestsellers in Books)

    Popular in these categories:

    #19 in  Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate
    #72 in  Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
    #97 in  Books > Computing & Internet > Databases > Database Design & Theory
  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
   SQL Server Tuning opens new browser window
www.Red-Gate.com/SQL_Refactor  -  Consistent Coding Across Your Team. SQL Code Tuning. Free Download. 
   SQL Server Tuning opens new browser window
www.Confio.com  -  Improve SQL Server Performance, Immediate ROI, Free Trial Download! 
   SQL tuning tool opens new browser window
www.sqlpower.com  -  Identify SQL bottlenecks in seconds Tune your worst performing SQL 
  
 

Product Description

Product Description

Dig into the internals of tuning and optimization features in SQL Server 2005—with insights from leading SQL Server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples to help you enable efficient, effective queries—and optimize database performance. Discover how to: •Create a baseline and monitor workload by using System Monitor and DMVs •Design, manipulate, and manage traces to isolate database performance issues •Audit user activity by using built-in default, black box, and Common Criteria traces •Analyze query execution using scans and seeks, joins, aggregations, unions, and parallelism •Generate efficient and cost-effective queries using cached plans or new plans •Detect and resolve locking, blocking, and deadlocking concurrency issues •Use best practices to diagnose and troubleshoot response time, throughput, and scalability issues PLUS—Includes Transact-SQL code samples and on the Web 


About the Author

Kalen Delaney, Series Editor for the Inside SQL Server line of books, has been working with SQL Server for two decades. She is a well-known expert in the SQL Server community and has been a Microsoft MVP since 1995. Kalen is a contributing editor and columnist for SQL Server Magazine and the author of several books, including Inside Microsoft SQL Server 2000.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product)
 
sql server 2005
sql server 2005 performance
sql server 2005 internals
sql server
t-sql
sql
relational databases
databases
transact-sql
sql server query tuning
internals

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?

Inside Microsoft SQL Server 2005: Query Tuning & Optimization: Query Tuning and Optimization
50% buy the item featured on this page:
Inside Microsoft SQL Server 2005: Query Tuning & Optimization: Query Tuning and Optimization 4.0 out of 5 stars (1)
£25.17
Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)
25% buy
Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning) 4.9 out of 5 stars (11)
£23.35
Inside SQL Server 2005: T-SQL Programming (Solid Quality Learning)
12% buy
Inside SQL Server 2005: T-SQL Programming (Solid Quality Learning) 5.0 out of 5 stars (2)
£20.58
Inside SQL Server 2005: The Storage Engine (Solid Quality Learning)
7% buy
Inside SQL Server 2005: The Storage Engine (Solid Quality Learning) 4.7 out of 5 stars (3)
£22.34

 

Customer Reviews

1 Review
5 star:    (0)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.0 out of 5 stars (1 customer review)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
3 of 3 people found the following review helpful:
4.0 out of 5 stars quite good, 11 April 2008
By Eric Le Bouffon (Angleterre) - See all my reviews
I read this book after "Inside SQL Server 2005: TSQL Querying" and I was not as impressed.
"TSQL Querying" uses some (invaluable) techniques that could run on SQL 2000 as well as 2005 specific stuff.
This book, on the other hand, is pretty much 2005 only BUT I did not think it had so much "impact".
I learned some very interesting stuff regarding DMVs (Dynamic Management Views) but I did not feel it deserved an entire book.
After that long wait (the book was delayed many times), it was a bit of an anticlimax.
It is a useful read but TSQL Querying seems much better to me
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback

Ad

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.