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. Select your Google News Location, add your key words and select your Google News Topics. The default setting is to display 3 items with their titles only in the feed. Drag and drop the RSS Just Better widget into the desired sidebar. Feed URL on a website is normally indicated by the orange RSS icon or the words RSS.
The simplest scenario is if you want to rebuild all the indexes and update all the statistics.
Run the next statement to update the column statistics only.
You can validate that only the column statistics were updated by looking at the update_date column which uses the STATS_DATE function to display the last date the statistics were updated.
One of the questions I was asked recently while speaking at the Los Angeles SQL Server Professionals Group and the Orange County SQL Server User Group (*) was regarding the order in which jobs like rebuilding indexes or updating statistics should be executed as part of the database maintenance activities.
In general you should consider the following important points, focusing in the fact that there are two kinds of statistics: index and column statistics.