Updating statistics sql server

I received an email from friend today asking how he can see when statistics were last updated in SQL Server.

updating statistics sql server-10

SQL Server Query Optimizer uses statistics to estimate the distribution of values in one or more columns of a table or index views, and the number of rows (called ) to create a high-quality query execution plan.Designed to launch directly within SQL Server Management Studio (SQL 2012 and above) for optimal usability and efficient workflow.Connect to database instances hosted in the cloud, such as SQL Server on Azure Virtual Machine (VM), SQL Server on Amazon Elastic Compute Cloud (EC2), and SQL Server on Amazon Relational Database Service (RDS).” I explained that in my experience, statistics maintenance can make more of a difference to performance than index maintenance can.I also noted that one of the big “maintenance goofs” that I’ve made in the past is to be overly eager to update statistics. Here’s some detail on why doing that can be so slow, and how it can eat up more resources than you might think.