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

Explain the steps to use transact-sql cursor?

516

What are relationships and mention different types of relationships in the dbms

548

What does normalization do to data?

532

Define magic tables in sql server?

561

Define constraints and give an example of their use?

557

What are four major operators that can be used to combine conditions on a where clause?

587

What is row_number()?

568

What is difference in performance between insert top (n) into table and using top with insert?

526

What is the data type of time?

504

What is a trigger? Why we need it?

527

What is partition in sql server?

520

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

616

What are distinctive joins find as a part of sql?

548

Explain the microsoft sql server delete command? : SQL Server Architecture

573

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

573