How do you measure the performance of a stored procedure?
Answer Posted / vb
Execution time is fast
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain a differential backup?
What does man by sql wildcard characters in sql server?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Do you know what is a linked server in sql server?
what are defaults? : Sql server database administration
Detail about the hardware which is supported by SQL server?
Explain the concept of recursive stored procedure.
What is explicit mode in sql server?
Define indexes?
Why do we use functions?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is the use of floor function in sql server?
What are the disadvantages of using querystrings to send data from one page to another?
Tell me what do you understand by a view? What does the with check option clause for a view do?
How do you open a cluster administrator?