|
|
Posted by szymon.strus on 06/19/07 07:54
> Have you tried running the queries that spawns the cursors from a query
> window to compare the results? It could be an issue with the query plan.
> If the database was upgraded from SQL 2000, be sure that you run
> sp_updatestats, as statistics are invalidated when you upgrade the database.
>
> What style of cursors do you use? Dynamic, keyset, static or forward_only?
>
Updating statistics didn't changed anything. Running the query from
the query analyzer takes about 5 seconds for both servers. Cursor from
my example is keyset-driven. Database Tuning Advisor for the specified
query created few indexes but it also hasn't speed up execution of
query.
Navigation:
[Reply to this message]
|