Answer Posted / anand
select count(*) from table_name will hold good if there isn't any WHERE clause in it as it is a AGGREGATE Function.. (just additional information)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How can we determine what objects a user-defined function depends upon?
How to concatenate two strings in SQL Server.
Explain atomicity?
How to use subqueries with the in operators in ms sql server?
What is candidate key with example?
What is open database communication (odbc)?
Using the customer, and order table in northwind database, please write a query to produce xml?
What are the differences between union, intersect, and minus operators?
Which sql server table is used to hold the stored procedure scripts?
please differentiate between delete and truncate?
What is the difference RDBMS and Graph Database?
What is left outer join in sql server joins?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
When does a workload on SQL Azure get throttled?
