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

What are statistics?

963

What is the use of keyword with encryption.

990

What are the new features of sql server 2008 r2 reporting service?

199

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1955

What is the difference between count () and rowcount ()?

965

Why SQL Agent is used?

1080

Explain full-text query in sql server?

959

Can group functions be used in the order by clause in ms sql server?

977

Explain in details security in SQL azure?

121

What is function of master database?

114

How to create function with parameter in sql server?

1056

what is datawarehouse?

1069

Explain timestamp datatype?

931

What are the purposes and advantages stored procedure?

908

What is a system database and what is a user database?

1036