数据库每日增长量脚本

1. 创建表
创建表，存储每天的表空间占用情况

CREATE TABLE [dbo].[t_rpt_table_spaceinfo]
(
    [schema_name] [sysname] NOT NULL,
    
     [table_name] [sysname] NOT NULL,
    
     [record_date] [date] NOT NULL,
    
     [record_time] [time](7) NOT NULL,
    
     [rows_count] [bigint] NULL,
    
     [reserved] [bigint] NULL,
    
     [data_size] [bigint] NULL,
    
     [index_size] [bigint] NULL,
    
     [unused] [bigint] NULL,
 
CONSTRAINT [PK_t_rpt_table_spaceinfo] PRIMARY KEY CLUSTERED 
(
    
[schema_name] ASC,
    [table_name] ASC,
    [record_date] ASC,
    [record_time] ASC