The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Login to Subscribe

Everything You Need to Know About SQL Server Indexes

Wed, Feb 13 2019 19:00 UTC

Everything You Need to Know About SQL Server Indexes

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. In this presentation, Janis Griffin, Senior Sales Consultant at Quest, will review current SQL Server index structures/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. Learning objectives: • Learn all the SQL Server index structures and how they work. • Learn how to identify which index types to use in specific situations. • Learn specific index options such as data compression, new features, and best practices on maintaining them.


Janis Griffin

Janis Griffin has over 25+ years of DBA experience including design, development and implementations of many critical database applications. Before coming to Quest Software, Janis held many DBA positions working with both real-time network routing databases and OLTP business to business applications. Janis has spoken at many SQL Saturdays as a Database Performance Evangelist and mentored many DBAs / Developers on best practices in database performance tuning.

Interested in Presenting at the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to DBA VG Leadership Team.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact DBA VG Leadership Team, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to DBA VG Leadership Team.

 

Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids