Again, thank you for your answer and interest ! 🙂

For the article part, i have read it in the past to. I cannot use the DAC connection, but from what i understood the column sys.system_internals_partition_columns .modified_count is similar to sys.sysrscols.rcmodified column.

For the sysindexes hint, thank you..that was what i was missing.

In my query for analysing statistics i had a filter rowcnt > 0 (to only get the tables that have data), which eliminated all the columns statistics from the returning set. I read now, that the rowcnt column is actually the number of rows in the index.

Thank you for your interest!