Andy Brownsword has a script for us:
In Management Studio we can view object details by hitting F7 in Object Explorer. It gives us basic metrics but I find it very slow to load for the details I typically need.
For that reason I though I’d share a script to turn to for metrics I commonly need. This query returns:
- The table details (schema, name, created date)
- The primary storage (Heap, Clustered, or Columnstore)
- The numbmer of Nonclustered / Columnstore Indexes
- The number of records and rough size for data / indexes
Click through for the script and an example of what it looks like.