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
How do I view a stored procedure in sql server query?
How you can get a list of all the table constraints in a database? : Sql server administration
What is b tree index?
What is a partition function in sql server?
How to update values in a table with update statements in ms sql server?
What are the components of dbms?
Why and when do stored procedure recompile?
What is a non clustered primary key?
What are different backups available in sql server?
What the different topologies in which replication can be configured?
Tell me what is log shipping?
Comment,Datatypes are unlimited
What is the difference between upgrade and migration in sql server?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Why use view instead of a table?
