江苏建设行业证书编号查询网站,自己怎么注册一个网站,软件开发公司网站,zedu小语种网站建设直接在sqlserver查询窗执行就OK了#xff0c;也是网上看到的#xff0c;对日常管理数据库工作者来说也蛮有用的#xff0c;可以及时的清理冗余的数据#xff0c;缓解数据库服务器的压力。Create Table #TableSpaceInfo --创建结果存储表(NameInfo NVarchar(50) ,RowsInfo i…直接在sqlserver查询窗执行就OK了也是网上看到的对日常管理数据库工作者来说也蛮有用的可以及时的清理冗余的数据缓解数据库服务器的压力。Create Table #TableSpaceInfo --创建结果存储表(NameInfo NVarchar(50) ,RowsInfo int ,Reserved NVarchar(20) ,DataInfo NVarchar(20) ,Index_Size NVarchar(20) ,Unused NVarchar(20))Declare TableName NVarchar(255) --表名称Declare CmdSql NVarchar(1000)Declare Info_Cursor Cursor ForSelect o.NameFrom dbo.sysobjects oWhere objectProperty(o.ID, NIsTable) 1 and o.Name not likeN#%% Order By o.NameOpen Info_CursorFetch Next From Info_CursorInto TableNameWhile FETCH_STATUS 0BeginIf exists (Select * From dbo.sysobjects WhereIDobject_ID(tablename) and objectProperty(ID, NIsUserTable) 1)Execute sp_executesql NInsert Into #TableSpaceInfo Execsp_Spaceused TBName, NTBName NVarchar(255), TBName TableNameFetch Next From Info_CursorInto TableNameEndClose Info_CursorDeallocate Info_cursorGO--itlearner注显示数据库信息sp_spaceused UpdateUsage TRUE--itlearner注显示表信息Select *From #TableSpaceInfoOrder By cast(left(lTrim(rTrim(Reserved)) ,len(lTrim(rTrim(Reserved)))-2) As Int) DescDrop Table #TableSpaceInfo
