Today, when clicking around SSMS, I discovered this little helpful trick, that you probably already knew but here it comes anyway.
If you want to see the number of rows in a table you can always use
but it has quite a nasty performance.
Another way to do it with much better performance
Ultimately you might want to get the row count for all the tables of your database.
But when it comes to SSMS there is an easy way, which calls the above query behind the scenes. In the Object Explorer Details, choose Tables right click on a column header and add row count and here you go…
Happy row counting !