Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?
Answer Posted / ramakrishna
count()
@@rowcount
sysindexes
dbcc chektable
sp_spaceused
excution plan
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
We need to perform what steps in the following order to work with a cursor?
What does sql server mean?
What are the acid properties?
What are the system database in sql server 2005?
Is null in sql server?
Difference between uniqe index and uniqe constraint?
Define self join?
What are date and time data types in ms sql server?
Explain transaction server consistency?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What is a fill factor?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Can you explain various data region available in ssrs with their use?
What command is used to delete a table from the database in the sql server and how?
What stored by the model? : sql server database administration