SQL Server Query Performance Tuning: Distilled

4.11 avg rating
( 9 ratings by Goodreads )
 
9781590591642: SQL Server Query Performance Tuning: Distilled
View all copies of this ISBN edition:
 
 

Queries are one of the fundamental tools for manipulating data within SQL Server, and knowledge o f them is a necessity. This book uses a focused and practical approach to provide you with the most efficient methods to employ with queries. It focuses on the means SQL Server provides to understand the cost of a query, and provides recommendations for ways to remedy poorly-performing queries.All the information provided is based on the author's real-world experience and highlights the most cost-effective situations to everyday use of SQL Server. He details the steps that you can follow to troubleshoot and resolve SQL query performance.SQL Server Query Performance Tuning Distilled shows you:How to identify problematic SQL queries How to analyze a query execution plan How to evaluate the effectiveness of the current indexing techniques How to evaluate the effectiveness of statistics How to analyze and avoid stored procedure recompilation How to analyze plan caching How to analyze and minimize blocking How to analyze and avoid deadlocks How to analyze the cost of using a specific cursor type

"synopsis" may belong to another edition of this title.

About the Author:

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.

"About this title" may belong to another edition of this title.

Other Popular Editions of the Same Title

9781590594216: SQL Server Query Performance Tuning Distilled (Books for Professionals by Professionals)

Featured Edition

ISBN 10:  1590594215 ISBN 13:  9781590594216
Publisher: Apress, 2004
Softcover

9781904347026: SQL Server Query: Performance Tuning Distilled

Wrox P..., 2003
Softcover

Top Search Results from the AbeBooks Marketplace

1.

Sajal Dam
Published by Curlingstone (2003)
ISBN 10: 159059164X ISBN 13: 9781590591642
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Curlingstone, 2003. Condition: New. book. Seller Inventory # M159059164X

More information about this seller | Contact this seller

Buy New
US$ 20.82
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Sajal Dam
Published by Apress (2003)
ISBN 10: 159059164X ISBN 13: 9781590591642
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Apress, 2003. Paperback. Condition: New. Seller Inventory # DADAX159059164X

More information about this seller | Contact this seller

Buy New
US$ 17.32
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

3.

Dam Sajalq
Published by Apress, Inc.
ISBN 10: 159059164X ISBN 13: 9781590591642
New Quantity Available: 1
Seller:
Majestic Books
(London, ,, United Kingdom)
Rating
[?]

Book Description Apress, Inc. Condition: New. pp. 500. Seller Inventory # 4694877

More information about this seller | Contact this seller

Buy New
US$ 61.36
Convert Currency

Add to Basket

Shipping: US$ 7.29
From United Kingdom to U.S.A.
Destination, Rates & Speeds