Workshop: SQL Server 2008 Indexes - Internals and Best PracticesDate: Friday, February 12, 2010 at 9:00a Pacific In this in-depth workshop, you'll learn about basic index structures, tools for exploring those structures, index design considerations and best practice guidelines.  This is a Deep-Dive, Advanced Workshop On-demand viewing available for one week and it includes a certificate on successful completion of the post-course quiz. Help Desk and FAQ  This workshop, by Microsoft SQL Server MVP Kalen Delaney will explore what you need to know about indexes, tools you can use when working with indexes, best practices and much more. This workshop is an in-depth look at how indexes work and how they can significantly impact the performance of your queries and your systems overall.If you'd like more information about Kalen Delaney, the presenter, there is an excellent summary here. You'll learn about key design considerations as you determine where, and what types of indexes will best support your queries. You'll also learn the value of unique indexes and included columns. You’ll find out about composite indexes, and how to determine the best indexes for your queries involving ANDs, ORs and JOINs. Last but not least, we’ll discuss best practices that you can put to use immediately as you review and update your designs to support the queries on your system. Kalen is the foremost authority on SQL Server internals and indexing - she's put together this workshop as a way to bring you key information you can apply to your work with SQL Server. Indexing is probably one of the most high-impact options you have in supporting your systems, enhancing query performance and using SQL Server to its fullest potential. This workshop will give you the information you need to be able to have the best options and approaches in place. You'll be learning from one of the most renowned and respected presenters in the world - and Kalen makes sure to present in a way that both makes sense and gives you key information you can put to use. SSWUG.ORG Workshops are not a simple webcast in these areas. We'll explain the options, show what you can watch for, see what you need to really pay attention to. Find out what's really important in this comprehensive vWorkshop. vWorkshop registration is only $99. CLICK HERE TO REGISTER NOW |
