I need a query that extracts the already existing collect stats sql commands on a DB because we will upgrade it, and after the upgrade we need to run the collect stats for each column and for every table right after the upgrade.
There are columns that are collected with a percentage...and some collect stats are on 2 or more columns..
Is there an already built query for that?
Thanks in advance.
Does the upgrade drop the current stats? I dont think so...but just to confirm..
I extracted the information form columnstatsv and MultiColumnStatsV and imported them into excel and built the queries i needed...