Viewing 4 posts - 1 through 4 (of 4 total)
Thank you for the hint, that pointed me to the right direction:
API cursor are used: sp_cursoropen, sp_cursorprepexec, sp_cursorfetch
and sp_cursorprepexec is called with
@ccopt =] concurrency_options OUTPUT = 0x0001 .....
December 21, 2009 at 3:46 am
GilaMonster (12/15/2009)
Are you doing the select WITH NOLOCK or are you explicitly setting the READ UNCOMMITTED isolation level?
No, I'm using default READ COMMITTED and autocommit true.
The select is not part...
December 15, 2009 at 12:48 pm
We tried to nail down the problem and found out that this is caused by a clustered index!???
One of the joined table in the select has a clustered index on...
December 15, 2009 at 10:30 am
thanks for answering.
Does anything perhaps insert mostly blank rows then come back and update them? Or do an update to null and then an update with the actual values? It's...
December 10, 2009 at 10:29 am
Viewing 4 posts - 1 through 4 (of 4 total)