Viewing 6 posts - 1 through 7 (of 7 total)
And the related topic
http://msdn.microsoft.com/en-us/library/ms174979.aspx
Temporary Tables
You can create local and global temporary tables. Local temporary tables are visible only in the current session, and global temporary tables are visible to...
May 18, 2010 at 2:07 am
TheSQLGuru (5/14/2010)
2) AND WC_ORDERITEM_F_M_CN.ORDER_DT_WID >= A.BLST_YEAR_DT_WID
that is...
May 18, 2010 at 1:26 am
elutin (5/12/2010)
Try to update table statistics after update:
UPDATE STATISTICS WC_PERSON_F_M_CN
Thanks,
Yes, we had check the index and statistics , both are fine. no use even though we update statistics...
May 13, 2010 at 12:20 am
Dave Ballantyne (5/12/2010)
Have you tried comparing the execution plans of the hanging and non hanging statements ?
Yes, it's same.
May 12, 2010 at 4:00 am
The UPDATE statement is the following, the UPDATE only last about 5 minutes first time.
And we already check the index and it's ok.
UPDATE WC_PERSON_F_M_CN ...
May 12, 2010 at 3:28 am
And we use the SQL Server 2005 Enterprise Edition with(sp3)
May 12, 2010 at 3:17 am
Viewing 6 posts - 1 through 7 (of 7 total)