http://www.sqlservercentral.com/Content tagged Blogs, statistics posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)I’ve been looking into the behaviour of statistics in SQL Server 2008 – so I’d like to present an overview from...

]]>http://www.sqlservercentral.com/blogs/ctrl-alt-geek/2013/02/14/sql-server-2008-statistics-what-does-a-dba-need-to-know/Wed, 20 Feb 2013 07:00:00 UThttp://www.sqlservercentral.com/blogs/ctrl-alt-geek/2013/02/14/sql-server-2008-statistics-what-does-a-dba-need-to-know/Per Books Online, DBCC SHOW_STATISTICS displays current query optimization statistics for a table or indexed view.  Basically it shows you...

]]>http://www.sqlservercentral.com/blogs/everyday-sql/2013/02/05/what-is-dbcc-show_statistics-telling-me-about-my-data/Thu, 14 Feb 2013 07:00:00 UThttp://www.sqlservercentral.com/blogs/everyday-sql/2013/02/05/what-is-dbcc-show_statistics-telling-me-about-my-data/By default statistics are created automatically within SQL Server. And, by default, these stats are updated automatically based on a...

]]>http://www.sqlservercentral.com/blogs/scarydba/2013/01/07/statistics-update-clarification/Fri, 11 Jan 2013 07:00:00 UThttp://www.sqlservercentral.com/blogs/scarydba/2013/01/07/statistics-update-clarification/Another key component of any good maintenance plan is updating statistics. Statistics are what help the SQL Server optimizer choose...

]]>http://www.sqlservercentral.com/blogs/cleveland-dba/2012/02/21/ryo-maintenance-plan-update-statistics/Mon, 27 Feb 2012 07:00:00 UThttp://www.sqlservercentral.com/blogs/cleveland-dba/2012/02/21/ryo-maintenance-plan-update-statistics/Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having...

]]>http://www.sqlservercentral.com/redirect/articles/71126/Thu, 02 Sep 2010 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/71126/