Salem Area SQL User Group

Next Meeting

Wednesday,

November

13

Janis Griffin -- Everything You Need to Know About SQL Server Indexes

  • In-Person @ Salem, Oregon, United States (map)
  • 11:30 - 13:00 (UTC-08:00) Pacific Time (US & Canada)
  • Language: English

SalemSQL Lunch & Learn
Wednesday, November 13th, 11:30 am to 1:00 pm
Event Sponsored by Quest
RSVP at Eventbrite

Location: 
Public Service Building 
(Across the street from the state Capitol, the SE building on the Capitol Mall) 
255 Capitol St NE, Salem, Oregon 97310
Basement Room A
 

Featured Presentation:

Everything You Need to Know About SQL Server Indexes

Janis Griffin, Senior Sales Consultant / DBA Quest Software

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.

About Janis :
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

PASSChapterLogo.jpg

 

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