Viewing 6 posts - 31 through 36 (of 36 total)
You may want to experiment with the SET IMPLICIT_TRANSATIONS option. I would be interested if this helps.
On the other hand, you could influence the level of 'locking' by using SET...
March 10, 2003 at 1:21 am
It really depends on the Query plan and the query plan may depend on table statistics, indexes etc.
One thing I noticed is the constant 1518 in your query. If this...
March 5, 2003 at 2:32 am
More news: Inside a transaction (and also inside an implicit insert..exec transaction) the SP does not have proper statistics on the tables. At least this is what the query...
March 5, 2003 at 1:08 am
Oh no !
It's the implict transaction for insert..exec, it makes SQL Server use a different query plan. Apparently statistics for temp tables are missing when the SP is executed within...
March 4, 2003 at 9:49 am
> you're saying overall its slower, or
> you've narrowed it to one line in the proc?
I put various 'print getdate' statements into the proc and found out that...
March 4, 2003 at 1:47 am
The Server runs 7.00.1077 (i.e.Service Pack 4 plus hot fix 7.00.1077).
The SQLServer Service uses "system account", my client logs in as SA. I have also tried different user log-ins, but...
February 19, 2003 at 4:08 am
Viewing 6 posts - 31 through 36 (of 36 total)