July 30, 2010 at 5:45 am
I want to put output of DBCC SHOW_STATISTICS (table_name, index_name) in table. But the problem is it returns three table And I want data of second resultset in table. Any way to do it??
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
July 30, 2010 at 6:43 am
You can specify exactly which table to return, by default it will return all three options.
To return the second table as you have specified run the following:
DBCC SHOW_STATISTICS(Table, Index) WITH DENSITY_VECTOR
Hope this helps,Rich
July 30, 2010 at 7:05 am
Thanks, this was a new learning for me...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply