Frequently Bought Together
Customers Who Bought This Item Also Bought
Inside 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 SQL Server 2005: T-SQL Programming (Solid Quality Learning) by Dejan Sarka; Roger Wolter Itzik Ben-Gan (Solid Quality Learning) |
SQL Server 2005 Reporting Services Step by Step Book/CD Package (Step by Step (Microsoft)) by Stacia Misner; Hitachi Consulting |
SQL Server 2005 Analysis Services Step by Step Book/CD Package (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.
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 & Optimization: Query Tuning and Optimization £25.17 |
 |
25% buy Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning) £23.35 |
 |
12% buy Inside SQL Server 2005: T-SQL Programming (Solid Quality Learning) £20.58 |
 |
7% buy Inside SQL Server 2005: The Storage Engine (Solid Quality Learning) £22.34 |
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 > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
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.
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. |
