get table size and row count

Question

Post reply

get table size and row count

sivakumar.thangavel

SSC Enthusiast

Points: 108
More actions
January 13, 2015 at 11:49 pm

#294372

Hi,
i need separated db tables size and row_count details.
share the script.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135377 More actions · Answer 1

NOW !

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

The views you want are sys.partitions or sys.dm_db_partiton_stats.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sivakumar.thangavel SSC Enthusiast Points: 108 More actions · Answer 3

sivakumar.thangavel

SSC Enthusiast

Points: 108

January 14, 2015 at 1:52 am

#1770038

any scripts available or not?

Grant Fritchey SSC Guru Points: 398911 More actions · Answer 4

SELECT * FROM sys.partitions;

SELECT * FROM sys.dm_db_partiton_stats;

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

sivakumar.thangavel (1/14/2015)
any scripts available or not?

http://www.urbandictionary.com/define.php?term=polite

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Brian Hibbert Ten Centuries Points: 1322 More actions · Answer 6

sivakumar.thangavel (1/14/2015)
any scripts available or not?

It's nice that you got a new job as a DBA and you have an assigned task, but it's rude to demand scripts from busy people and ask them to do your job for you. It's doubly rude since such scripts already exist and are freely available, but you couldn't be bothered to do a little research.

Grant was nice enough to tell you where the information exists. I'll give you another clue. The object_id references the table.