Determining when statistics were last updated in SQL Server?

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

DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants

sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx
Returns information about the queries that have acquired a memory...

Event Notifications 101 – Intro to Event Notifications

Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server.  And...

Finding SQL Server Installs with Powershell, Again

But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...

Free SQL Server 2012 Installation Guide

Everyone’s favorite four letter word is back, FREE! Yes, it is time I gave back to the community since I’ve...

Last Weeks Top “Reading” Links #28

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...

Microsoft GeoFlow new Excel 2013 add-in

Hi

Microsoft released new add-in (Preview) for Excel 2013 and we decided to do a video so here it is...

New SQL Server Cumulative Updates

Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for...

PASS Business Analytics Conference Presentation Slides

Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics...

PASS SQL Saturday in Chicago Presentation Slides

Thanks to everyone who attended my sessions “What exactly is Business Intelligence?” and “Building an Effective Data Warehouse Architecture” at the PASS SQL...