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 is the stuff and how does it differ from the replace function?

1004

How can sql server instances be hidden? : sql server security

1053

How to perform backup for certificates in sql server? : sql server security

1024

Explain the steps needed to create a scheduled job?

884

what is a join and explain different types of joins? : Sql server database administration

911

What are commit and rollback in sql?

1052

In case you have filters in your report, when filters will be applied in cached report instance?

103

Explain the advantages of merge replication?

894

Is sql server 2016 free?

885

How to create a view with data from multiple tables?

965

Explain the difference between clustered and non-clustered index?

870

Can you force a query to use a specific index?

887

What are dml triggers and types of dml triggers?

921

what is the difference between openrowset and openquery?

1025

How to execute a stored procedure in ms sql server?

1069