Viewing 7 posts - 1 through 7 (of 7 total)
Thanks for all your replies. UPDLOCK is the key, special thanks to Prasad Bhogadi and ron_k.
To ron_k,
May 12, 2005 at 8:49 pm
Will it be expensive (in term of time) if I first test (use SELECT COUNT) before I do the real SELECT? The SELECT statement to executed will involve joining more...
January 7, 2005 at 6:40 pm
First I used all three...
January 6, 2005 at 1:13 am
October 2, 2004 at 1:56 am
The content of sqlstp.log
23:18:08 Begin Setup
23:18:08 8.00.194
23:18:08 Mode = Normal
23:18:08 ModeType = NORMAL
23:18:09 GetDefinitionEx returned: 0, Extended: 0x0
23:18:09 ValueFTS returned: 1
23:18:09 ValuePID returned: 1
23:18:09 ValueLic returned: 1
23:18:09 System: Windows NT...
September 30, 2004 at 9:51 am
Viewing 7 posts - 1 through 7 (of 7 total)