评估插入会增长的页级空间

评估插入会增长的页级空间 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 a sys.indexes b b.index_id ) c d.index_id = c.index_id dataid,column_id,c.object_id 11 ),NonClustedIndexSize 12 AS( (a.object_id) name ,a.object_id,MAX(c.dataneme) index_name, c.dataid ,) a.max_length ) ,(,) ) ,)) ,,,,) ) , sys.columns a sys.types b ON a.user_type_id = b.user_type_id NonClustedIndexColumn c a.column_id = c.column_id dataid a.object_id,c.dataid 27 ) 28 , ClustedHeapSize AS( (a.object_id) name ,a.object_id,MAX(c.name) index_name, c.index_id ,) a.max_length ) ,(,) ) ,)) ,,,,) ) , sys.columns a sys.types b ON a.user_type_id = b.user_type_id sys.indexes c a.c.index_id a.object_id,c.index_id ) 43 ,RowSize AS 44 ( (name),) 46 FROM ( NonClustedIndexSize ClustedHeapSize 50 ) a ) rowsize

posted on