BEGIN:VCALENDAR VERSION:2.0 PRODID:-//SQLBits/com CALSCALE:GREGORIAN METHOD:PUBLISH X-MS-OLK-FORCEINSPECTOROPEN:TRUE BEGIN:VEVENT DTSTART:20130502T080000Z DTEND:20130502T160000Z LOCATION:SQLBits Conference - Exhibition B SUMMARY:Performance Tuning with Indexes: Internals and Best Practice DESCRIPTION:
Indexes allow SQL Server to access your data in the most efficient manner. Understanding exactly how our indexes are structured and stored internally can give you a deeper understanding of what indexes will be useful for your queries. Knowing how indexes are useful can allow us to generalize some best practice
recommendations. In this seminar we’ll look at the following topics:

.

Basic Index Structures
    Clustered vs nonclustered
    Unique vs non-unique
    Included columns

Tools for Exploring Index Structures

Index maintenance
    Page splits
    Fragmentation and Defragmentation

Index Design Considerations
    AND’s/ OR’s
    JOIN’s
    Composite Indexes

Best Practice Guidelines

Columnstore Index Storage

Columnstore Index Guidelines

X-ALT-DESC;FMTTYPE=text/html:

Performance Tuning with Indexes: Internals and Best Practice

Indexes allow SQL Server to access your data in the most efficient manner. Understanding exactly how our indexes are structured and stored internally can give you a deeper understanding of what indexes will be useful for your queries. Knowing how indexes are useful can allow us to generalize some best practice
recommendations. In this seminar we’ll look at the following topics:

.

Basic Index Structures
    Clustered vs nonclustered
    Unique vs non-unique
    Included columns

Tools for Exploring Index Structures

Index maintenance
    Page splits
    Fragmentation and Defragmentation

Index Design Considerations
    AND’s/ OR’s
    JOIN’s
    Composite Indexes

Best Practice Guidelines

Columnstore Index Storage

Columnstore Index Guidelines

Kalen Delaney

Kalen Delaney has been working with SQL Server for over 25 years, and provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server 2012 Internals, from Microsoft Press. Kalen blogs at www.sqlblog.com.

http://www.SQLServerInternals.com UID:SQLBITS1462SEQUENCE:0 DTSTAMP:20130526T022023Z END:VEVENT END:VCALENDAR