Inside Microsoft SQL Server 2005: Query Tuning and Optimization

Inside Microsoft SQL Server 2005: Query Tuning and Optimization
ISBN-10
0735621969
ISBN-13
9780735621961
Series
Inside Microsoft SQL Server 2005
Category
Computers / Languages / SQL
Pages
406
Language
English
Published
2008
Publisher
Microsoft Press
Author
Kalen Delaney

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

Get the book

Amazon.com
Amazon.com
Search the book
eBay.com
eBay.com
Search the book

Similar books

  • JDBC API Tutorial and Reference: Universal Data Access for the Java 2 Platform
    JDBC API Tutorial and Reference: Universal Data Access for the Java 2 Platform
    By Seth White

    This license allows and is limited to the creation and distribution of clean room implementations of this specification that ... For more information , please contact : Pearson Education Corporate Sales Division ; 201 W. 103rd Street ...

  • XML: Designing XML internet applications
    By David Megginson

    XML: Designing XML internet applications

  • 数据挖掘在医学中的应用
    数据挖掘在医学中的应用
    By 徐颖, 张维朋

    由于各部分自由度不相等,因此各部分离差平方和不能比较,必须将各部分离差平方和除以相应自由度,其即比值称为均方差,简称为均方。组间均方: ,组内均方:。这时根据这两个值可以进行F检验,即: }gs}image81-5.jpg}/gs} ,表示各个样本不是来自同一总体, ...

  • Inside Microsoft SQL Server 2008: T-SQL Querying
    Inside Microsoft SQL Server 2008: T-SQL Querying
    By Itzik Ben-Gan

    Tackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and...

  • Inside Microsoft SQL Server 2008: T-SQL Programming
    Inside Microsoft SQL Server 2008: T-SQL Programming
    By Itzik Ben-Gan

    Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the...

  • How to Set Up and Maintain a World Wide Web Site: The Guide for Information Providers
    How to Set Up and Maintain a World Wide Web Site: The Guide for Information Providers
    By Lincoln D. Stein

    Second Editionnow available! World Wide Web (WWW) sites have been blossoming at an astounding rate, with good reason; WWW technology has proven extraordinarily effective at creating a flexible, interactive, and...

  • Handbook of Relational Database Design
    Handbook of Relational Database Design
    By Candace C. Fleming, Barbara Von Halle

    This book provides a practical and proven approach to designing relational databases. It contains two complementary design methodologies: logical data modeling and relational database design. The design methodologies are independent...

  • Advanced Oracle PL/SQL: Programming with Packages
    Advanced Oracle PL/SQL: Programming with Packages
    By Steven Feuerstein

    Steven Feuerstein's first book,Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and...