Download page: SSMS Release date: 2017-08-07 Support Version: 2008/2012/2014/2016/2017/Azure Author: Microsoft Free version: Yes Price: No SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.
SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server.
As a result, you can INSERT/EXEC the output from the statistics header (or any of the others) into a table.
The syntax lets you specify a table or indexed view along with a target index name, statistics name, or column name (see below): returns statistics information for the index name, statistics name, or column name of the specified table or in indexed view, however, if you only want to see the statistics update date for all statistics objects that exists for the tables, indexes, and indexed views in the database, you query system catalog view is the best way to see each statistics object information that exists for the tables, indexes, and indexed views in the database.
This catalog view exists in SQL Server 2005 and later.
In the final post for this series, we'll talk about statistics maintenance. Unlike indexes, statistics don't become fragmented, but the histograms associated with those statistics become out of date as the data in the column changes.
While statistics maintenance is important, you have to keep in mind that updating stats can also cause plan recompilation and that has costs of its own.
Answer: Actually, this question is much more interesting than it seems.
Most people think the only way to access the "last modified date" for a statistic is to access it through the header information using DBCC SHOW_STATISTICS: It's true that the first result set shows the "header" information including when the statistics were last updated (second column in first result set) but how can you use this data programmatically?To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are valid for its columns.Download page: RML Utilities for SQL Server Release date: 2014-12-12 Support Version: 2008/2012/2014/2016 Author: Microsoft Free version: Yes Price: No The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing.Related: Update the Statistics on Recently Modified Tables Only In SQL Server 2005, they added STAT_HEADER (as well as DENSITY_VECTOR and HISTOGRAM) as options to DBCC SHOW_STATISTICS.Each of these, when added, will produce ONLY that particular tabular data set.So, like anything else, it should be done, but as DBAs, we should make some educated decisions about how and when.