Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / virgilio
The statements from above are correct but one main thing
that might speed a proc up is the naming convention.
If you create a user defined Storproc and you name it by
using the "Sp_" prefix SQL thinks is a System Store Proc
and goes to the Master DB to look for the Object instead of
looking locally.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between web edition and business edition?
Explain about system database?
What are dml triggers and types of dml triggers?
Why use stored procedures in sql server?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Explain transaction isolation levels in sql server?
What is filestream?
What are four major operators that can be used to combine conditions on a where clause?
What are the grouping functions?
Explain the properties of sub-query in sql server?
What is clustered primary key?
Tell me what is the difference between locking and multi-versioning?
Characterize join and name diverse sorts of joins?
Why and when do stored procedure recompile?
What is ddl command?
