Viewing 6 posts - 1 through 6 (of 6 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...
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 6 (of 6 total)