评估插入会增长的页级空间 1 ; with nonclustedindexcolumn as 2 ( sys.index_columns d (a.index_id dataid,a.name dataneme, b. * from sys.indexes a sys.indexes b b.index_id ) c d.index_id = c.index_id dataid,column_id,c. object_id 11 ),nonclust
评估插入会增长的页级空间
1 ;with nonclustedindexcolumn as 2 ( sys.index_columns d(a.index_id dataid,a.name dataneme, b.* from sys.indexes asys.indexes b b.index_id ) c d.index_id = c.index_iddataid,column_id,c.object_id11 ),nonclustedindexsize12 as((a.object_id) name ,a.object_id,max(c.dataneme) index_name, c.dataid,) a.max_length ) ,(,) ) ,)) ,,,,) ) , sys.columns asys.types b on a.user_type_id = b.user_type_idnonclustedindexcolumn c a.column_id = c.column_iddataid a.object_id,c.dataid27 )28 , clustedheapsize as((a.object_id) name ,a.object_id,max(c.name) index_name, c.index_id,) a.max_length ) ,(,) ) ,)) ,,,,) ) , sys.columns asys.types b on a.user_type_id = b.user_type_idsys.indexes c a.c.index_id a.object_id,c.index_id )43 ,rowsize as44 ((name),)46from ( nonclustedindexsize clustedheapsize50 ) a)rowsize
posted on
，