Tags » Space

Number of Rows/Size in a table

-- Database level
--select top 10 * FROM sys.dm_db_partition_stats
select @@servername servername,r.SchemaName,r.TableName,r.row_count,s.reserved_kb,s.used_kb from (
SELECT OBJECT_NAME(object_id) TableName
,OBJECT_SCHEMA_NAME(object_id) SchemaName
,SUM(row_count) AS row_count
FROM sys.dm_db_partition_stats
WHERE 1=1
AND index_id < 2
GROUP BY OBJECT_NAME(object_id),OBJECT_SCHEMA_NAME(object_id)) r
inner join 
(SELECT OBJECT_NAME(object_id) TableName,
OBJECT_SCHEMA_NAME(object_id) SchemaName,
sum(reserved_page_count)<em>8 reserved_kb,
sum(used_page_count)</em>8 used_kb
FROM sys.dm_db_partition_stats
WHERE 1=1
GROUP BY OBJECT_NAME(object_id),OBJECT_SCHEMA_NAME(object_id)) s
on r.TableName=s.TableName and r.SchemaName=s.SchemaName and r.SchemaName'sys'
order by 2 desc
… 196 more words
Administration

KNOW ABOUT HOW THE STARS AND THE SUN WERE FORMED

Stars are the most widely recognized astronomical objects, and represent the most fundamental building blocks of galaxies. They are responsible for the manufacture and distribution of heavy elements such as carbon, nitrogen, and oxygen in the universe. 244 more words

Space

The Perseids shower reaches peak: how to see the best meteor spectacle of the year

The annual Perseids meteor shower reaches peak on Tuesday, August 11, when it`s supposed to offer the best meteor show of the year, according to NASA… 181 more words

Space