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
Why I am getting this error when renaming a database in ms sql server?
Can you explain what is indexed view? How to create it?
Which language is supported by sql server?
What is change data capture (cdc) feature?
How you provide security to cube? : sql server analysis services, ssas
Explain the different index configurations a table can have?
What is a full text index?
what is a correlated sub-query? : Sql server database administration
if no size is defined while creating the database, what size will the database have? : Sql server administration
Please illustrate physical database architecture? : SQL Server Architecture
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?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What are the instances when triggers are appropriate?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
which backup strategy you are following at ur company