This is sql 2000. If I do the following, select id from table where id between 1 and 8000 I have index seek, however with the case in, I get table...
Currently I have the index on the id for the following select statment: SELECT id , (CASE WHEN XTYPE =...
Hi Satya, the index is on the rowid. I beleived the while loop is the one causing problem. If individual account is processing, it took around 2...
Hi all, I have the code below, which used for stock analysis base on the first in first out. As you can see if need a lot of help....the currently...
Yes, both table have non-clustered index. thanks
I trying to filter over a million records that was import by the third party database. The reason for filtering is that the data contain too many...
Hi Adriaan, thank you for replying. I just want to make sure, when you says 'current connection' , when 10 users log into the web site, if all off...
Hi all, With the statement below, what will happen if more then 1 persons run at the same time? thanks DECLARE @TranStarted BIT IF(...
Separate names with a comma.
