SQL SERVER – Effect of Normalization on Index and Performance

Of late, I have been using Twitter quite frequently, and I am gradually discovering its usefulness. I received a Direct Message (or DM in terms of twitter) asking if I can comment on the effect of normalization on the Index and its performance in one twit! Now honestly speaking, this was new for me. I never expected to be quizzed like this. If you are using Twitter, then you must be aware that one twit contains only 140 characters. I was supposed to give answer on such a big subject in just 140 letters. An interesting fact is that normalization and the Index are not really closely related. The right question should have been – what is the effect of normalization on performance?

Read More

SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar

In today’s article I have combined two different questions. I was fond of SQL Server Debugger feature in SQL Server 2000. To my utter disappointment, this feature was withdrawn from SQL Server 2005. However, because of loads of requests from developers it was re-introduced in SQL Server 2008. Let us learn about how to customize toolbars. 

Read More

SQLAuthority News – Registration and Competition – TechEd on Road – Ahmedabad – June 20, 2009 Saturday

We have an upcoming grand event of TechEd on Road organized in Ahmedabad. This is a FREE event and ANYBODY who loves technology can attend it. This event will provide a precious opportunity to learn, interact and network with tech enthusiasts. I encourage you all to be a part of it and experience the joy of learning in a healthy and fun environment.

Read More