Making Microsoft SQL Server 2008 Fly
Play Making Microsoft SQL Server 2008 Fly
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.