You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries.
This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown.
This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.
No material found.