InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 17:08:47 GMT20http://www.sqlservercentral.com/Forums/Topic17367-92-1.aspxi'm seeing this, too - the problem is, we are having i/o issues and this is one of the highest i/o operations going.One thing to note is that "Auto Update Stats" is off, and this appears to be called from SQL Agent, although i have been unable to find a job. It's happening every 15 minutes.Where can it come from?AmandaThu, 03 Mar 2011 14:28:40 GMTRottengeekhttp://www.sqlservercentral.com/Forums/Topic17367-92-1.aspxWhat you're seeing is an automatic statistics update. Nothing to be concerned about.Wed, 26 Mar 2008 04:28:33 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic17367-92-1.aspxHi ,we too feel the same.. There is only one update which doesn't involve any indexes or any other statemets..For Simple update like the below , it is listing the above statements..update a set TotalQty = Tqty from XXX_item_wise_taxes_tabl a, (select invoice_no Tinvoice_no, sum(invoice_qty) TQty from XXX_item_wise_taxes_tabl group by invoice_no) b where invoice_no = Tinvoice_no.Any guessesWed, 26 Mar 2008 04:17:24 GMTAmulyahttp://www.sqlservercentral.com/Forums/Topic17367-92-1.aspxNo one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!Mon, 20 Oct 2003 08:00:00 GMTSite Ownershttp://www.sqlservercentral.com/Forums/Topic17367-92-1.aspxhi guys, while i run a Stored Proc and profiling this , i had encountered these kinda statements.SELECT <b>statman</b>([ListingAddressPostalCode],[ListingAddressStreetNumber],[ListingAddressStreetName],[ListingAddressUnitNumber],[DataSourceID],[AMListingID],@PSTATMAN) FROM (SELECT TOP 100 PERCENT [ListingAddressPostalCode],[ListingAddressStreetNumber],[ListingAddressStreetName],[ListingAddressUnitNumber],[DataSourceID],[AMListingID] FROM [dbo].[LISTING] WITH(READUNCOMMITTED,SAMPLE 1.000000e+002 PERCENT) ORDER BY [ListingAddressPostalCode],[ListingAddressStreetNumber],[ListingAddressStreetName],[ListingAddressUnitNumber],[DataSourceID],[AMListingID]) AS _MS_UPDSTATS_TBL OPTION (BYPASS OPTIMIZER_QUEUE, MAXDOP 1)any help would be appreciated.Praveen Kumar PeddiThu, 16 Oct 2003 15:03:00 GMTpeddi_praveen