Recently my boss asked me, why the databases (Microsoft SQL Server 2005) of our customers are so big. With the following SQL-Statements I could give more or less an answer to my boss.<\/p>\n
EXEC sp_MSforeachtable @command1=\"INSERT INTO PW_SPACE EXEC sp_spaceused '?'\" select * from PW_SPACE order by rows desc select sum(rows) as Rows, Recently my boss asked me, why the databases (Microsoft SQL Server 2005) of our customers are so big. With the following SQL-Statements I could give more or less an answer to my boss. CREATE TABLE PW_SPACE( name varchar(255), rows int, reserved varchar(255), data varchar(255), index_size varchar(255), unused varchar(255) ) GO EXEC sp_MSforeachtable @command1=”INSERT INTO PW_SPACE EXEC sp_spaceused ‘?'” GO select * from PW_SPACE order by rows desc GO select sum(rows) as Rows, convert(varchar(255), sum(convert(int, substring(data,0,len(data)-2)))) + ‘ KB’ as Data,…<\/p>\nCREATE TABLE PW_SPACE(
\n\tname varchar(255),
\n\trows int,
\n\treserved varchar(255),
\n\tdata varchar(255),
\n\tindex_size varchar(255),
\n\tunused varchar(255)
\n)
\nGO<\/p>\n
\nGO<\/p>\n
\nGO<\/p>\n
\nconvert(varchar(255), sum(convert(int, substring(data,0,len(data)-2)))) + ' KB' as Data,
\nconvert(varchar(255), sum(convert(int, substring(index_size,0,len(index_size)-2)))) + ' KB' as Indexsize
\nfrom PW_SPACE
\nGO<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"