Count Rows in a Table is SQL server or Count from the whole Database

Working in database some times we need to retrieve total count of rows in a table. Cursors are mostly used to loop through the whole table to count rows in most cases(which i ve seen) ...