Making Microsoft SQL Server 2008 Fly

Download

Right click “Save as…”

Slides (view online)
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.

Follow 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.