How to view Table size , index size
View/show rows in table with out select
Use "sp_spaceused"
Use myDB
GO
sp_spaceused "trans"
GO
How to view database information in SQL Server
Mssql, Microsoft sql server, SSAS, SSRS ,SSIS , Analysis Service, Reporting Service, Integration Service, XMLA ,MDX ,SQL