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
What is the stuff and how does it differ from the replace function?
How can sql server instances be hidden? : sql server security
How to perform backup for certificates in sql server? : sql server security
Explain the steps needed to create a scheduled job?
what is a join and explain different types of joins? : Sql server database administration
What are commit and rollback in sql?
In case you have filters in your report, when filters will be applied in cached report instance?
Explain the advantages of merge replication?
Is sql server 2016 free?
How to create a view with data from multiple tables?
Explain the difference between clustered and non-clustered index?
Can you force a query to use a specific index?
What are dml triggers and types of dml triggers?
what is the difference between openrowset and openquery?
How to execute a stored procedure in ms sql server?