Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?
Answer Posted / mathan
1.select count(*) from <table name>
2.select count_big(*) from <table name>
3.select rows from sysindexes where id=?
Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Do you know what is a linked server in sql server?
What is check constraint in sql server?
Can sql servers linked to other servers?
How does normalization work?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is the difference between functions and scalar functions?
What happens if you are trying to access a schema not owned by you?
Define Wed Edition in SQL Azure?
What is index in an assignment?
What are audit control procedures?
What is indexed view? How to create it?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
How can you check the level of fragmentation on a table?
How to find the service pack installed? : sql server database administration