CREATE Table #t (Name varchar(100), Row int, Reserved Varchar(32), data varchar(32), IndexSize varchar(32), Unused varchar(32))
INSERT INTO #tExec sp_MSforeachtable @command1="Exec sp_SpaceUsed '?' "
SELECT Name, RowFROM #t
DROP TABLE #t
Ads 720 x 90
Total Pageviews
Label List
- Architecture
- Art of SQL Server
- asynchronous mirroring
- csv
- dmv
- find outdated Statistics
- Free SQL Server tools
- index fragmentation
- Installation
- Katmai
- Learn SQL Server 2005
- Maintenance Plan
- outdated Statistics
- Reset Identity column
- Scripts
- SPID
- sql server 2008
- sys.dm_db_index_physical_stats
- sys.dm_exec_connections
- tsql
- update statistics