Indexing Fundamentals for Microsoft SQL Server

Download this episode

Download Video

Description

Having the right indexes supporting your databases is a critical need. But how do you determine what indexes are required? Should you have single or multi-column indexes? Should the index be filtered? What are included columns and columnstore indexes and when should they be used? In this session, we explore various ways to implement indexes and provide the performance expected out of your databases.

For more information, check out this course on Microsoft Virtual Academy:

Day:

1

Session Type:

Breakout

Code:

DBI-B302

Room:

Room 291

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      dirq

      Will you be using the Database Engine Tuning Adviser or another tool?

    • User profile image
      StrateSQL

      @dirq: I'll be mentioning DTA, but that won't be the focus.  The key will be looking at the choices that can be made and then leveraging the statistics that SQL Server provides to help make decisions.

    • User profile image
      dmwiz

      Always a good topic.  Hopefully you will give tips on when indexing is bad, so I can share these with our vendor.  Tongue Out

    • User profile image
      MB1

      Awesome!  Looking forward to it!!

       

    • User profile image
      motuyet456
      Are you going to provide access to the scripts you used during your presentation? That would be very helpful.
    • User profile image
      jemiller

      Good video. Thanks for it. It was helpful. I've always wondered whether it's good enough to have one index on FirstName and another LastName or whether it's necessary to have a single index containing both columns. So, it was good to find out about how that works for sure. Also, it was good to confirm that foreign keys should pretty much always be indexed. Previously, ORMs such as EF didn't add indexes for foreign keys automatically, but, I noticed that the current version does.

    • User profile image
      StrateSQL

      @motuyet456: I've posted the scripts from the presentation on my blog, the url is http://bit.ly/14Cm9DM.  If I can get them up on this site, I'll do that as well.

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.