Answer Posted / koti khammam
It will reduce the network traffic between client and
server so that the number of calls between client and
server are reduced.
It's an performance issue.
| Is This Answer Correct ? | 23 Yes | 5 No |
Post New Answer View All Answers
What do you understand by a view? What does the with check option clause for a view do?
How to filter records of table in SQL SERVER?
What is difference between cte and view?
What do you understand by check constraint in sql server?
What is the difference between getdate and sysdatetime?
How to create a dml trigger using create trigger statements?
Do you think BCNF is better than 2NF & 3NF? Why?
Can two tables have the same primary key?
Can you explain about buffer cash and log cache in sql server?
What is SQL Azure Federations?
Can we use custom code in ssrs?
Differentiate between a having clause and a where clause.
How to use the inserted and deleted pseudo tables?
What is surrogate key? : sql server analysis services, ssas
What are the advantages of sql stored procedure?