Hi all. I am a new SQL Profiler user trying to baseline our eCommerce site. I am receiving EventClass 80, Missing Join Predicate (hereinafter MJP), often enough to be concerned about what may happen during very high traffic. I have isolated the query, included at the bottom of this post (cleaned up)...

Hi I am running SQL Server 2000 (ent edition) on windows 2003. My server is running slow but task manager shows that cpu performance is low, like 20%. There are no locks, I still have 21gb left on my disk. All the files for All the DB's are set to unlimited growth. Can anyone tell me what should...

We are using SQL Server 2000. In production we are facing deadlock problems. If we try to run a trace then users starts complaining that there are not able to get into the application. What do you think are the options that we have to trace down deadlock issues? We have hundreds of stored procedures...