Viewing 3 posts - 46 through 48 (of 48 total)
I did update usage for the entire databse, did an update statistics with full scan, and also did a rebuild of all teh indexes.
It did help. That "BAD" query now,...
June 9, 2008 at 12:11 pm
#826248
The query you sent me runs in 1 second on both servers. Very nice and I thank you very much for that.
Also, the execution plans are the same.
But as...
June 9, 2008 at 11:19 am
#826220
I appreciate your comments more than you know. We just purchesed these two servers. We made them Identical. Restored each databse from teh same backup file. Databases are exactly the...
June 9, 2008 at 11:03 am
#826212