Скачать или смотреть Table Indexing 101

In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2000-2012 databases. We will also be looking into the new indexing features that are available in SQL Server 2012 (and SQL Server 2005/2008) and how you the .NET developer can make the best use of them to get your code running its best.

Learn why indexes need to be created

Learn how indexes can help your databases performance

Learn how indexes can hurt your databases performance
Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2008 including the Microsoft Certified Master as well as being a Microsoft MVP for several years. Denny has written several books and dozens of technical articles on SQL Server management and how SQL Server integrates with various other technologies.

Hosted by Steve Cantrell of DBAFundamentals



The basics for a rock solid foundation!
Full event description http://fundamentals.sqlpass.org/Meeti...