SQL SERVER – SQL Server Performance: Indexing Basics – SQL in Sixty Seconds #006 – Video

SQL SERVER - SQL Server Performance: Indexing Basics - SQL in Sixty Seconds #006 - Video 60

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, analyzing, and maintaining indexes.

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

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.

More on Indexes:

I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can. Here is the interview of Vinod Kumar by myself.

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

Solarwinds
, ,
Previous Post
SQL SERVER – Speed Up! – Parallel Processes and Unparalleled Performance – TechEd 2012 India
Next Post
SQL SERVER – Install Samples Database AdventureWorks for SQL Server

Related Posts

2 Comments. Leave new

Leave a Reply

Menu