Ok. Seems I had experimented with an index and change the type to be (EID, Type, Value) on the Attribute table when the left-most column should have...
It almost seems like it all of a sudden it uses the wrong execution plan or something of that nature. 9 times out of 10 it will run fine.
Right. It's not hanging, it's tripping over itself. It is doing something, just not sure what. The sql statement will run fine (I'm loading data...
Thanks Merrill! I'm going to compare times with your SQL and what I wrote and let you know how it turns out. I'll just put the type = 'name', etc in...
There was a problem with the SQL in the first post. I have updated it so it will create the tables correctly. Also, here is output from sp_lock...
Sample data: Insert into entity (1,'human') Insert into entity (2,'human') Insert into entity (3,'human') Insert into entity (4,'human') Insert into...
I'm trying to provide as much information as possible so here is goes: SQL 2005 SP1 + June Hotfixes, Win2003 SP1 with latest Hotfixes. Machine is...
Separate names with a comma.
