Alternative to STATS_DATE?

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  March 11, 2008 at 1:59 pm

  #187404

  Anyone know if there is an alternative to STATS_DATE? I don't to use dynamic SQL for what I'm working on and have to be with in the context of the database being queried, and STATS_DATE only works while in the context of the target database ... so I'm curious to as if there is an alternative.

  Thanks

• Grant Fritchey

  SSC Guru

  Points: 398979

  More actions

  March 12, 2008 at 5:48 am

  #788479

  I doubt it's going to help, but you can call this in a cross database query. I used the example from BOL:

  SELECT 'Index Name' = i.name, 'Statistics Date' = STATS_DATE(i.object_id, i.index_id)

  FROM Adventureworks.sys.objects o

  JOIN Adventureworks.sys.indexes i ON o.name = 'Address' AND o.object_id = i.object_id;

  GO

  You can also get that info from DBCC SHOW_STATISTICS.

  Otherwise, I think you might be stuck. Sorry. Not very helpful.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning