SQL Server – Learning SQL Server Performance: Indexing Basics – Video

Today I remember one of my older cartoon years ago created for Indexing and Performance.

SQL Server - Learning SQL Server Performance: Indexing Basics - Video indexcartoon

Every single time when Performance is discussed, Indexes are mentioned along with it. In recent times, data and application complexity is continuously growing.  The demand for faster query response, performance, and scalability by organizations is increasing and developers and DBAs need to now write efficient code to achieve this.

DBA and Developers

A DBA’s role is critical, because a production environment has to run 24×7, hence maintenance, trouble shooting, and quick resolutions are the need of the hour.  The first baby step into any performance tuning exercise in SQL Server involves creating, analysing, and maintaining indexes.

Though we have learnt indexing concepts from our college days, indexing implementation inside SQL Server can vary.  Understanding this behaviour and designing our applications appropriately will make sure the application is performed to its highest potential.

Video Learning

Vinod Kumar and myself we often thought about this and realized that practical understanding of the indexes is very important. One can not master every single aspects of the index. However there are some minimum expertise one should gain if performance is one of the concern.

We decided to build a course which just addresses the practical aspects of the performance. In this course, we explored some of these indexing fundamentals and we elaborated on how SQL Server goes about using indexes.  At the end of this course of you will know the basic structure of indexes, practical insights into implementation, and maintenance tips and tricks revolving around indexes.  Finally, we will introduce SQL Server 2012 column store indexes.  We have refrained from discussing internal storage structure of the indexes but have taken a more practical, demo-oriented approach to explain these core concepts.

Note: Click here for video learning

If you do not see play button, please login first.

Course Outline

Here are salient topics of the course. We have explained every single concept along with a practical demonstration. Additionally shared our personal scripts along with the same.

Introduction

  • Fundamentals of Indexing
  • Index Fundamentals
  • Index Fundamentals – Visual Representation

Practical Indexing Implementation Techniques

  • Primary Key
  • Over Indexing
  • Duplicate Index
  • Clustered Index
  • Unique Index
  • Included Columns
  • Filtered Index
  • Disabled Index

Index Maintenance and Defragmentation

Introduction to Columnstore Index

Indexing Practical Performance Tips and Tricks

  • Index and Page Types
  • Index and Non Deterministic Columns
  • Index and SET Values
  • Importance of Clustered Index
  • Effect of Compression and Fillfactor
  • Index and Functions
  • Dynamic Management Views (DMV) – Fillfactor
  • Table Scan, Index Scan and Index Seek
  • Index and Order of Columns

Final Checklist: Index and Performance

Well, we believe we have done our part, now waiting for your comments and feedback.

Note: Click here for video learning

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Index
Previous Post
SQL SERVER – T-SQL Errors and Reactions – Demo – SQL in Sixty Seconds #005 – Video
Next Post
SQLAuthority News – Download Microsoft SQL Server 2012 RTM Now

Related Posts

11 Comments. Leave new

  • Hi pinal, I am very big fan of you and your blog..
    Your blog helps us in realtime too..

    This course sounds great to me and i can learn much more information.
    where can i get this course?

    I really appreciate you for your valuable time ….

    Reply
  • How to get the video?

    Reply
  • Pinal, Course outline looks really good. Plz lets us know how to access videos

    Reply
  • Allen Heydari
    March 8, 2012 11:25 pm

    No Videos.

    Reply
  • Hi Pinal,

    I am interested too.. please let us know how to access ..?

    thanks,
    Laxmi

    Reply
  • Could you please let us know how to access the video. Thanks

    Reply
  • you should probably make at least a brief mention that it’s a subscription service (minus the free trial anyway). between this, and your over-promotion of expressor, i think it’s about time to unsubscribe to your blog. It used to be good. thanks for what I have learned.

    Reply
  • Not seeing the video any where.
    to launch the video, is it something we need to pay? please dont hide the things.

    Reply
  • Cathal O'Brien
    October 21, 2012 6:30 pm

    Hi Pinal, Do you have a location where I can get all the scripts used on this course? As it would save me having to type them as I’m watching.

    Reply

Leave a Reply