Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
farrokhp
Starting Member
15 Posts |
 Posted - 2011-03-10 : 04:27:07
|
| how can I know in sql2005 when was the last time stat_update happens in server? |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2011-03-10 : 10:56:39
|
| I think you need to be more specific. What kind of update are you talking about. What are you specifically trying to capture?r&r |
 |
|
|
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-03-10 : 23:40:33
|
| If you need Index update statistics Information then use below commandssp_helpstats 'TableName', 'ALL'DBCC SHOW_STATISTICS('TableName', IndexName)--Ragu ThangavelJunier Sql Server DBA |
|
|
|
farrokhp
Starting Member
15 Posts |
Posted - 2011-03-12 : 08:06:26
|
| Thanks Ragu, that's what I was looking for |
|
|
|
|
|
|
sql maintain