SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.

Error 2501 : Cannot find a table or object with the name . Check the system catalog. This is very generic error beginner DBAs or Developers faces. The solution is very simple and easy. Follow the direction below in order. Fix/Workaround/Solution: Make sure that correct Database is selected. If not…
Read More

SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion

MIS2007 is really going good. There are many things going on. As I mentioned in my previous article, It is really pleasure to meet industry leaders. There was discussion about what is good for database RAID 5 configuration or RAID 10. This subject is always very interesting. We were discussing…
Read More
All Articles indexchecklist-600x400

SQL SERVER – Index Optimization CheckList

Index optimization is always interesting subject to me. Every time I receive requests to help optimize query or query on any specific table. I always ask Jr.DBA to go over following list first before I take a look at it. Most of the time the Query Speed is optimized just following basic rules mentioned below. Once following checklist applied interesting optimization part begins which only experiment and experience can resolve.

Read More

SQLAuthority News – Author Visit – The 2007 Marketing Innovation Summit, Las Vegas

I am attending The 2007 Marketing Innovation Summit“, Las Vegas. It started on 5/6/2007 and will continue till 5/9/2007. Unica Corporation has arranged this conference. The MIS 2007 Agenda includes: Case studies and best practices Sessions focused on Relationship Marketing, Internet Marketing and Marketing Operations Hands on “how to” sessions…
Read More