SQLAuthority News – Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index

Performance Tuning has been my favorite subject always. I love this subject the most. I personally have enjoyed every aspect of performance tuning. Quite often I have seen that when it is about performance, people end up talking about Indexes. Index for sure can help performance, but it is like secret weapon and it must be used carefully as the same thing can be dangerous. I have personally attended many sessions that are related to Indexes as well as how to identify the correct index and remove useless indexes. I always wanted Indexing presentation to bring much more than these usual topics.

Session Inspiration

Driven with coming up something different around indexes, I created this presentation. This presentation is based on the famous book ‘The Art of War’ written in sixth century BC by Sun Tzu. This book is composed of 13 chapters, each of which is devoted to one aspect of warfare, and it is said to be the definitive work on military strategies and tactics of its time, and it is still read for its military insights. I am heavily inspired by this book, and I have always treated performance tuning as a war.

Here are the three subjects which I will be covering in my online presentation.

How to defeat an opponent

  • Using Weapon
  • Carry a convenient weapon
  • Use anything as weapon
  • Use Counter Intelligence
  • Use spy network
  • Use statistical data points
  • The Lords of War
  • Extra-ordinary intellect
  • Supreme heroic ability

I have created three demos to support the above three sections. I am very sure that this is one of the most interesting and inspiring sessions for performance tuning. Here are the details for the session.

Sessions Details

Title: Ancient Trade of Performance Tuning – Index, Beyond Index and No Index
Timing: September 29, 2011 11:45am-12:45pm IST
SQL Server Indexes are like a double-sided sword. If used properly it gives tremendous performance improvement of the server. However, there is a dark side of the Index as well, which one needs to learn before using them to improve the performance of the query. In this session, we will go over various concepts of the Indexes, which are not common but extremely important.
Location: Register for Virtual Tech Days

Giveaways

During my session, I will ask a simple question. I will give away 5 copies of my SQL Server Wait Stats books to five random people who will answer it correctly. If you already have this book, I strongly suggest you attend this session as this session will take the performance tuning concepts to next level. I will make sure that I personally autograph and send these copies to your way.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

3 thoughts on “SQLAuthority News – Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index

  1. Hello Sir,

    Couple days ago I wrote a comment on one of Your posts treating about Indexes:
    http://blog.sqlauthority.com/2007/04/23/sql-server-understanding-new-index-type-of-sql-server-2005-included-column-index-along-with-clustered-index-and-non-clustered-index/
    I hope it doesn’t botter You if I repaet my question here, as I think that there’s more people reading actual posts rather than the older one’s, so I have more chance to get the answer.
    Here’s the orriginal message:

    **********
    Hello Sir,

    Could You please explain, why clustered indexes should be used on columns with low selectivity?
    If I have a table with unique, identity column, where I keep for exemple a transaction number, I thought that clustered
    index is the best for it. Each line is just put after the other one.
    And if I have an index with low selectivity, and I want to do some insert / update / delete operations on that table, won’t it take more time
    to do these operations?
    I’am a little bit confused now …
    Thank’s in advance!
    Ewelina

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s