Another very interesting development. The style_id is actually a decimal (12,0) not an integer. The stored procedures were being called with a...
Is there a way to date the execution plan? Maybe its not being updated like I think it is... It occurred to me because I also noticed that even with...
The delete statements are part of a TRANSACTION if that makes any difference. Again, I run the same query on TEST and LIVE. Its another stretch but...
Ok. Like I said it was a kind of a stretch, but I couldnt think of anything else to try... So I'm back to square one... I cant figure out why its...
Then what is the point of "the movement of allocated pages from the end of a file to unallocated pages in the front of the file"? I was hoping it...
Thank you for your response. During off hours the execution times are very similar so I dont believe that is the problem. The DELETE statement is...
I have a 160GB database on SQL 2000 (SP4). In an attempt to speed up a stored procedure I restored the database on another server so that I could...
Separate names with a comma.
