Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.
Frequently Bought Together
Customers Who Bought This Item Also Bought
Inside Microsoft® SQL Server™ 2005: The Storage Engine (Solid Quality Learning) by Kalen Delaney (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) |
Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning) by Dejan Sarka; Roger Wolter Itzik Ben-Gan (Solid Quality Learning) |
Microsoft® SQL Server™ 2005 Reporting Services Step by Step (Step by Step (Microsoft)) by Stacia Misner; Hitachi Consulting |
Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft)) by Reed Jacobson; Stacia Misner; Hitachi Consulting |
Product details
Would you like to update product info or give feedback on images?
|
Customers Viewing This Page May Be Interested in These Sponsored Links(What is this?) |
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.
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)
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)
|
What Do Customers Ultimately Buy After Viewing This Item?
 |
50% buy the item featured on this page: Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization £25.67 |
 |
22% buy Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning) £23.07 |
 |
13% buy Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning) £23.07 |
 |
8% buy Inside Microsoft® SQL Server™ 2005: The Storage Engine (Solid Quality Learning) £24.84 |
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
Most Helpful Customer Reviews
Share your thoughts with other customers: Create your own review
|
|
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
The Body Shop |
More From Kalen Delaney
Microsoft® SQL Server® 2008 Internals Explore the definitive guide to the internals and architecture of the...
Read more
|
Treat Someone
With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is). |
||||||||
| |||||
Your Recent History
(What's this?)|
You have no recently viewed items or searches.
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. Look to the right column to find helpful suggestions for your shopping session. |
Continue Shopping: Top Sellers
| ||||
Amazon Home | |
| International Sites: United States | Germany | France | Japan | Canada | China | |
| Business Programs: Sell on Amazon | Fulfilment by Amazon | Join Associates | Join Advantage | |
| Customer Service | Help | View Basket | Your Account | |
| About Amazon.co.uk | Careers at Amazon | |
| Conditions of Use & Sale | Privacy Notice © 1996-2009, Amazon.com, Inc. and its affiliates |