Skip to main content
Submitted

Display row count from a dmv on data preview

  • March 27, 2018
  • 1 reply
  • 0 views

Forum|alt.badge.img

It would be useful to have the preview data window always display the "approximate" row count of the table on open by querying it from the dmv (dm_db_partition_stats) without having to have to use the "Count rows" which can be quite heavy on bigger tables.

1 reply

Forum|alt.badge.img
  • Known Participant
  • March 27, 2018

Hi Andri,

I agree that count can get pretty laborious on larger tables, and agree that an approximate count would be extremely helpful to show just by default!  I'm upvoting this for sure. 

It's not a big thing, but I think it would be a significant "quality of life" improvement.

Best regards,

Doug Wynkoop