This tutorial shows how to use range and pattern matches in a basic single table query in SQL Server 2005 and 2008.

Need a fast data integration solution, but don’t have the time or budget for heavy performance tuning? Come learn how to maximize your ROI by applying trusted design patterns to your Integration Services packages. We talk about how to set performance expectations, and how to put together a simple framework to record benchmarks for your ETL process. We go over the basics of smart package design, and then look at a number of design patterns for common data warehousing problems, such as Slowly Changing Dimension processing, Range Lookups, and Change …

Execution plan reuse is one of the most important aspects of building well-performing and scalable SQL Server solutions. But it’s also the one that is often overlooked during the design phase and becomes very difficult to troubleshoot later. In this session we discuss in detail the following aspects of SQL Server execution plans: compilation, re-compilation, parameterization, caching, reuse, and aging. You will leave this session with full understanding of how to improve your server’s performance by increasing execution plan reuse (and how to avoid reuse in case this is necessary).

Download …

This lesson introduces you to Microsoft SQL Server 2008 and SQL Management Studio. Youíll learn how to create a database, add tables to it, and populate it with data. You’ll then use that data and bind it to a template control.

Download source code

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 …