Cost for cheap SAN storage where I work is £3,000 per TB ($4,500 USD) and £10,000 per TB ($16,000 USD) for the 5 year TCO. As you can imagine every...

I have been using databases on large SAN's for about 15 years. A well managed SAN should not need DBA's to micro manage for hot storage. Typically I request LUN's...

My first thought was to try to use sp_foreachdb

CREATE TABLE #databases(DbName SYSNAME, DbSize BIGINT, Remarks NVARCHAR(100))

INSERT INTO #databases EXEC SP_DATABASES

ALTER TABLE #databases ADD ObjectCount INT

EXEC SP_MSFOREACHDB

'USE [?] ;

UPDATE #databases...