So You Are Tuning Some Bad SQL Statement....

-

Sql statement tuning is the hardest tuning I guess. Its having so many things to look after, the query itself, question which is asked for which the query is written, missing indexes , bad execution plan and the list goes on and on and on. So how can you be some what good in solving this impossible looking puzzle of statement tuning? Greg Rahn has posted a very good post for troubleshooting bad execution plans. Its a must read in my opinion as execution plan is like the x-ray report of your statement's flow and by tuning how is your statement is going through, you can get the maximum performance! Have a read, its an excellent post!

Comments

Post a Comment

Popular posts from this blog

A Poetic MasterPiece By Faraz.....

-
I am a big fan of good poetry. I am not a poet myself  but where ever I do find anything good written, I try to collect and share it. Surely enough, my first preference would always be Punjabi poetry. But there is no such thing that I wont read from any where else. Whatever is good, I try to make sure that I don't miss it! There are some poets which have created history with their writings. Late Ahmed Faraz is among those handful which wrote timeless pieces from his pen. Saying anything about him would like showing torch to the sun. So without wasting any more time, I would like to share a poetic masterpiece from him which I read today only and instantly fell in love with it. This is in Hindi and I shall translate it English in a while. Please note, this does has lots of words from Urdu as well.I shall put the meanings of those words in the end of both Hindi and English versions. First, in Hindi, Dost ban kar bhi nahin saath nibhane wala, Wohi andaaz hai jaalim ka jamane
Read more

Feelings Revealed Truly & Musically....

-
In music, out of the most pure forms of it, one is Qawalli . This is that form of music which is sung by the people who are not mere singers but devotees of God. This form of music was not a part of commercial music industry some time ago but due to its magic, its now very common to hear this in almost every where. Despite its used now in the commercial music industry, still the original form of it with minimum music instruments and claps of the singers while singing is the most popular one and remains untouchable. There are many singers who sing this form of music but some have made it a household name due to their singing. Late Nusrat Fateh Ali Khan   is among those very few who singers who are known as the masters of this devine music form. Out of millions of Qawalli songs available, there are some which hit straight in the heart. There is one that I am listening from some time and thought to share with you all. This one was specially recommended to me by my friend Sumit who himsel
Read more

Hello From Singapore….

-
Yes, I am at Singapore . Its been a while since I have come to this office where I am sitting right now, Suntec Tower 4 . The last time when I came here was in 2006. That was the first time when I came overseas for delivering a training program and this time again, the reason is same. Its so good to be back here and meet few persons whom I had met long time back and who actually taught me the few of the first lessons about the tactics of delivering a sessions. The session which I am handling right now is a VERY tough one and I am trying my best to keep things running smoothly. Hope all remains and goes fine. Its time to go for lunch. Been very long that I have seen food courts here at Suntec . Hope will find something to eat :-) .
Read more