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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-05 : 09:10:23
|
| Ken writes "Microsoft SQL Server 7.00 - 7.00.961 (Intel X86)Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)How do I find out the sample size used when update statistics was last run?I know that I can find out the number of rows used to create the index statistics using DBCC SHOW_STATISTICS.I would prefer to find out the option used with the UPDATE STATISTICS command, e.g. WITH FULLSCAN but if this is not possilbe I would like a SQL statement that return the same value as the DBCC command, for example by extracting the value from the statblobs column.Any ideas how to do this?thanksKenn" |
|
|
|
|
|
Last statistics sample size.