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.
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.
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
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 (https://blog.sqlauthority.com)
Thanks Pinal for attention/reminder :)
Couple days ago I wrote a comment on one of Your posts treating about Indexes:
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:
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!
Looks like the Art of war is a very insipiring book, will sure check it out.