Updating a row in sql server
This code will work with all current and previous versions of SQL Server back through SQL 7.0.
That is why so many of us "roll our own" index maintenance solutions as it were. Ah, at any rate, by only maintaining indexes that are fragmented, statistics updates do not occur globally against the tables/indexes in your databases. I've touched upon this in an earlier tip, SQL Server's engine will update the statistic when: Based upon this criteria, there will be many cases where the underlying data changes in such a way or in such levels that the statistics that exist for an index will not be indicative of the actual data in the database.If Length is NULL, the update operation removes all data from Offset to the end of the Lob_column_name value.