count() @@rowcount sysindexes dbcc chektable sp

Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?

Question Posted / ramakrishna

Answer Posted / ramakrishna

count()
@@rowcount
sysindexes
dbcc chektable
sp_spaceused

excution plan

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

We need to perform what steps in the following order to work with a cursor?

1219

What does sql server mean?

1071

What are the acid properties?

1006

What are the system database in sql server 2005?

1045

Is null in sql server?

994

Difference between uniqe index and uniqe constraint?

982

Define self join?

1032

What are date and time data types in ms sql server?

1095

Explain transaction server consistency?

976

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1069

What is a fill factor?

1088

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1137

Can you explain various data region available in ssrs with their use?

976

What command is used to delete a table from the database in the sql server and how?

1114

What stored by the model? : sql server database administration

953