PDC 2009

Making Microsoft SQL Server 2008 Fly

Download this episode

Download Video

Description

Hear best practices for getting the fastest query processing for general-purpose applications, including logical and physical database design, statistics management, query design, query tuning, problems areas to avoid, and more. Learn which query constructs cause the query optimizer to rely on guesses rather than accurate statistical estimates for the number of rows returned by sub-plan. Also learn how to work from an understanding of your query and update patterns to develop a high-performance set of indexes for database tables. Find out how parameters and local variables effect plan selection and optimality, and how that can impact performance of your applications. See how your choice of data types for join keys can affect join performance, and how data compression affects CPU overhead and I/O.

Day:

2

Code:

SVR31

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.