No Clustered Index on MonitorEvent

May 14, 2007 at 9:26 PM
I'm not sure if this is on purpose or not, but there isn't a clustered index/constraint on MonitorEvent. Normally I would expect EventID to be the primary key and be clustered, but sometimes someone will make an other index clustered instead of the primary key. Of course this may be on purpose, but there have been a number of bugs related to heap tables within SQL Server.

Thanks,

SQL_Guru
Coordinator
May 15, 2007 at 4:00 AM
You are right - not sure how that happened, but unless there is a specific reason I always cluster based on the primary key.
I will rectify that for the next release.
Thanks.
Coordinator
May 15, 2007 at 4:00 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.