Answer Posted / uma lakshman
Hokar, You are right. But using count(*) is not optimal.
I wud suggest going for sysindexes table to find the number
of rows in a particular table.
SELECT rows FROM sysindexes WHERE id = OBJECT_ID
('table_name')
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
What is sql server locking?
What it means to be triggered?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is measure group, measure? : sql server analysis services, ssas
Explain nested trigger in sql?
What are the advantages of log shipping?
What are indexes in sql?
What is the current limitation of the size of SQL Azure DB?
Explain syntax for disabling triggers?
What is right outer join in sql server joins?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Can you create a logon trigger in sql server 2005 express edition?
Explain indexed views?
What is the bookmark lookup and rid lookup?
Is mysql the same as sql server?