LloydDobler
Technical User
Can someone point me in the right direction on finding some info on the following? I need to create some queries that will detail the size in KB of all tables, indexes along with their row counts, as well as schema names, table and index names as well. I've searched this forum, BOL, google, but have only found this:
select object_name(id) [table name],[rows], [table size]
= convert(varchar, dpages) + ' KB' from
sysindexes where indid in (0,1)
order by dpages desc
"I don't want to sell anything, buy anything or process anything as a career. I don't want to sell anything bought or processed... or buy anything sold or processed... or process anything sold, bought or processed... or repair anything sold, bought or processed. You know, as a career, I don't want to do that."
select object_name(id) [table name],[rows], [table size]
= convert(varchar, dpages) + ' KB' from
sysindexes where indid in (0,1)
order by dpages desc
"I don't want to sell anything, buy anything or process anything as a career. I don't want to sell anything bought or processed... or buy anything sold or processed... or process anything sold, bought or processed... or repair anything sold, bought or processed. You know, as a career, I don't want to do that."