<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Regularly Update Statistics for Ascending Keys</title><link>http://blogs.msdn.com/ianjo/archive/2005/11/10/491551.aspx</link><description>Ascending key columns, such as IDENTITY columns or datetime columns representing real-world timestamps, can cause inaccurate statistics in tables with frequent INSERTS because new values all lie outside the histogram. Consider updating statistics on such</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>re: Regularly Update Statistics for Ascending Keys</title><link>http://blogs.msdn.com/ianjo/archive/2005/11/10/491551.aspx#5611545</link><pubDate>Tue, 23 Oct 2007 02:17:38 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:5611545</guid><dc:creator>msdngtnexus</dc:creator><description>&lt;p&gt;Is there anyway to get to the statistics histogram and/or the stats header information without using dbcc show_statistics. I would like to run some queries across all the stats objects in the database?&lt;/p&gt;
&lt;p&gt;I looked for some DMVs to do this but couldnt find any.&lt;/p&gt;
&lt;p&gt;Thanks.&lt;/p&gt;
</description></item><item><title> Ian Jose s WebLog Regularly Update Statistics for Ascending Keys | fire pit</title><link>http://blogs.msdn.com/ianjo/archive/2005/11/10/491551.aspx#9780072</link><pubDate>Fri, 19 Jun 2009 09:01:29 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9780072</guid><dc:creator> Ian Jose s WebLog Regularly Update Statistics for Ascending Keys | fire pit</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://firepitidea.info/story.php?id=1018"&gt;http://firepitidea.info/story.php?id=1018&lt;/a&gt;&lt;/p&gt;
</description></item></channel></rss>