see this post on the statistics, after a rebuild you still need to update statistics on col.

http://sqlblog.com/blogs/ben_nevarez/archive/2009/10/06/rebuilding-indexes-vs-updating-statistics.aspx

AS far as the large tables goes, they only work around I...

if anyone is woundering....here is a great link to the answer.

This explains buffer cache hit ratio well!

http://www.sqlservercentral.com/blogs/a_sql_tracker/archive/2010/03/16/high-buffer-cache-hit-ratio-low-page-life-expectancy.aspx

thanks STEVE

the exact code is this (below)---

the SP (sp_BackupAllFull_Schedule) is canned logshipping SP for biztalk, which uses DTS for backups, it places a mark on all DB's and then backs...

Hi Steve,

This a Sql Agent job I am running( have treid to run it from a Query window as well) ,

I have SA rights.

This is for a "biztalk...

just FYI for anyone......I added a sort operator and sorted on the Key before it went into the SCD...its to have fixed it.

My guess was in the backgroup it was...