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
How do I create a stored procedure in dbml?
Can a database be shrunk with users active?
What is a trigger and its types?
How do I manually uninstall an instance of sql server 2016?
What are user-defined functions (udfs) in sql server?
How to enter unicode character string literals in ms sql server?
What is acid db?
What is table valued function and scalar valued functions?
Call by value and call by reference in procedure and function, with NOCOPY.
What are the different type of replication in sql server?
Define self join?
What do you mean by an execution plan? How would you view it?
How to find Duplicate Records In table?
Is sql server is free?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration