Shulou(Shulou.com)06/01 Report--

The first method:

First query the source table data:

Select 'insert into @ tmp exec sp_spaceused' + name From sys.tables with (nolock) order by create_date desc

Create a temporary table and insert the queried source table data into the temporary table, and then query the data in the final temporary table:

Declare @ tmp table (tbname varchar, tbrows int,reserved varchar, datatb varchar, index_size varchar, unused varchar)

Insert into @ tmp exec sp_spaceused table1

Insert into @ tmp exec sp_spaceused table2

Insert into @ tmp exec sp_spaceused table3

Insert into @ tmp exec sp_spaceused table4

Insert into @ tmp exec sp_spaceused table5

Insert into @ tmp exec sp_spaceused table6

Insert into @ tmp exec sp_spaceused table7

Insert into @ tmp exec sp_spaceused table8

Insert into @ tmp exec sp_spaceused table9

Insert into @ tmp exec sp_spaceused table10

Select * from @ tmp order by cast (replace (reserved,' KB','') as bigint) desc

Get the final desired data results.

The second method:

Select

Tb.name as tbname

, ps.reserved_page_count * 8 as KB

, ps.row_count

From

Sys.dm_db_partition_stats ps with (nolock)

, sys.tables tb with (nolock)

Where

Ps.object_id=tb.object_id

And tb.create_date > = '2017-10-23 21 purl 4415. 010'

Order by

Ps.reserved_page_count desc

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.