sqlserver2000 数据库的几个库的可用空间为0MB sqlserver2000 数据库的几个库的可用空间为0MB,但是数据库操作正常,日志为1MB,数据库文件和日志文件都设定为自动增长10%,但是它却一直是可用空间为0MB操作系统Windows 2003 Server数据库是从原来的Windows2000上导入的,导入方法是用附加进来的不知道是为什么,有没有高手帮忙解答一下,谢谢啦。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 --2005查询表空间使用情况SELECT ServerName = CONVERT(sysname, SERVERPROPERTY('ServerName')), DatabaseID = DB_ID(), DatabaseName = DB_NAME(), ObjectID = DATA.id, Owner = USER_NAME(DATA.uid), ObjectName = DATA.Name, Reserved = CONVERT(decimal(15, 2), DATA.Reserved / SPER.PageSperMB), DataSize = CONVERT(decimal(15, 2), (DATA.DataSize + DATA.[TextSize]) / SPER.PageSperMB), IndexSize = CONVERT(decimal(15, 2), (DATA.IndexSize - DATA.DataSize - DATA.[TextSize]) / SPER.PageSperMB), UnUsedSize = CONVERT(decimal(15, 2), (DATA.Reserved - DATA.IndexSize) / SPER.PageSperMB), DATA.RowsFROM( SELECT O.id, O.uid, O.name, O.xtype, Reserved = ISNULL(SUM(CASE WHEN IX.indid IN (0, 1, 255) THEN CONVERT(dec(15), IX.reserved) ELSE 0 END), 0), DataSize = ISNULL(SUM(CASE WHEN IX.indid < 2 THEN CONVERT(dec(15), IX.dpages) ELSE 0 END), 0), [TextSize] = ISNULL(SUM(CASE WHEN IX.indid = 255 THEN CONVERT(dec(15), IX.used) ELSE 0 END), 0), IndexSize = ISNULL(SUM(CASE WHEN IX.indid IN (0, 1, 255) THEN CONVERT(dec(15), IX.used) ELSE 0 END), 0), Rows = ISNULL(MAX(CASE WHEN IX.indid < 2 THEN IX.rows ELSE 0 END), 0) FROM dbo.sysindexes IX WITH(NOLOCK) INNER JOIN dbo.sysobjects O WITH(NOLOCK) ON IX.id = O.id WHERE O.xtype IN ( 'U')--, 'S') AND O.status > =0 AND (IX.indid < 2 OR IX.indid = 255) GROUP BY O.id, O.uid, O.name, O.xtype)DATA CROSS JOIN( SELECT PageSperMB = 1048576. / low, low FROM master.dbo.spt_values WHERE number = 1 AND type = 'E' )SPERORDER BY ObjectName, OwnerGO http://blog.csdn.net/claro/archive/2008/10/09/3040302.aspx查询数据库空间使用状况/*-- ===================================================================版本: SQL Server 2000, 2005功能: 查询数据库空间使用状况=================================================================== --*/ USE [要查询空间信息的库名]GO 有条件删除大量数据超时问题 子查询返回的值多于一个 请问,我用sql2000将所有储存过程生成sql脚本,可是执行的时候报错。 求助一高难SQL语名 求一个SQL语句 急!!!!!!!!! bcp大数据量导入数据时出错 字符问题(SQL Server 2008) 执行了SQL查询语句后,我是多表联合查询的,怎么令重复的行只显示一行数据??? 在数据库中模拟多人同时操作数据表考验数据库的承受能力 如何通过Internet访问SQL数据库 请教sql server agent问题? mssql中某两个字段表数据复制出现的问题!
--2005查询表空间使用情况
SELECT ServerName = CONVERT(sysname, SERVERPROPERTY('ServerName')), DatabaseID = DB_ID(), DatabaseName = DB_NAME(), ObjectID = DATA.id, Owner = USER_NAME(DATA.uid), ObjectName = DATA.Name, Reserved = CONVERT(decimal(15, 2), DATA.Reserved / SPER.PageSperMB), DataSize = CONVERT(decimal(15, 2), (DATA.DataSize + DATA.[TextSize]) / SPER.PageSperMB), IndexSize = CONVERT(decimal(15, 2), (DATA.IndexSize - DATA.DataSize - DATA.[TextSize]) / SPER.PageSperMB), UnUsedSize = CONVERT(decimal(15, 2), (DATA.Reserved - DATA.IndexSize) / SPER.PageSperMB), DATA.RowsFROM( SELECT O.id, O.uid, O.name, O.xtype, Reserved = ISNULL(SUM(CASE WHEN IX.indid IN (0, 1, 255) THEN CONVERT(dec(15), IX.reserved) ELSE 0 END), 0), DataSize = ISNULL(SUM(CASE WHEN IX.indid < 2 THEN CONVERT(dec(15), IX.dpages) ELSE 0 END), 0), [TextSize] = ISNULL(SUM(CASE WHEN IX.indid = 255 THEN CONVERT(dec(15), IX.used) ELSE 0 END), 0), IndexSize = ISNULL(SUM(CASE WHEN IX.indid IN (0, 1, 255) THEN CONVERT(dec(15), IX.used) ELSE 0 END), 0), Rows = ISNULL(MAX(CASE WHEN IX.indid < 2 THEN IX.rows ELSE 0 END), 0) FROM dbo.sysindexes IX WITH(NOLOCK) INNER JOIN dbo.sysobjects O WITH(NOLOCK) ON IX.id = O.id WHERE O.xtype IN ( 'U')--, 'S') AND O.status > =0 AND (IX.indid < 2 OR IX.indid = 255) GROUP BY O.id, O.uid, O.name, O.xtype)DATA CROSS JOIN( SELECT PageSperMB = 1048576. / low, low FROM master.dbo.spt_values WHERE number = 1 AND type = 'E' )SPERORDER BY ObjectName, OwnerGO
查询数据库空间使用状况/*-- ===================================================================版本: SQL Server 2000, 2005功能: 查询数据库空间使用状况=================================================================== --*/ USE [要查询空间信息的库名]GO