SQL SERVER – Public Training and Private Training – Differences and Similarities – Public Training vs Private Training

Earlier this year, I was on Road SQL Server Seminars. I did many SQL Server Performance Trainings and SQL Server Performance Consultations throughout the year but I feel the most rewarding exercise is always the one when instructor learns something from students, too. I was just talking to my wife, Nupur –…
Read More

SQL SERVER – Index Created on View not Used Often – Observation of the View

I always enjoy writing about concepts on Views. Views are frequently used concepts, and so it’s not surprising that I have seen so many misconceptions about this subject. To clear such misconceptions, I have previously written the article SQL SERVER – The Limitations of the Views – Eleven and more….…
Read More

SQL SERVER – Index Created on View not Used Often – Limitation of the View 12

I have previously written on the subject SQL SERVER – The Limitations of the Views – Eleven and more…. This was indeed a very popular series and I had received lots of feedback on that topic. Today we are going to discuss something very interesting as well. Let us learn about the issue of index created on view on used often.

Read More

SQLAuthority News – A Successful Community Tech Days in Ahmedabad – December 11, 2010

We recently had one of the best community events in Ahmedabad. We were fortunate that we had SQL Experts from around the world to have presented at this event. This gathering was very special because besides Jacob Sebastian and myself, we had two other speakers traveling all the way from Florida (Rushabh Mehta) and Bangalore (Vinod Kumar).There were a total of nearly 170 attendees and the event was a blast. Here are the details of the Tech Days event.

Read More