Name 3 ways to get an accurate count of the number of records in a table?

Question

If I by mistake delete a large amount of rows from the remote server, Is there any way to get back these records?

Answer 1

SELECT * FROM table1
SELECT COUNT(*) FROM table1
SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2