1) By default, the UPDATE STATISTICS statement updates both index and column statistics.
Using the COLUMNS option of this statement will update column statistics only.
Using UPDATE STATISTICS WITH FULLSCAN will scan the entire table.
In XML Showplan output, the Seek Predicate New element appears in the operator in which it is defined.All you have essentially done there is increased the overhead in working with the "table" in the first place by having several instances (i.e.open in two different DBs) of it under a single SQL Server instance. I have a client with a 6 million row table in SQL Server that contains 2 years worth of sales data.The database does not readjust the high water mark and does not release the space immediately.You must issue another statement later to complete the operation.