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 data tier application?
Define full outer join in sql server joins?
What is the use of partition by in sql server?
Explain rdbms?
Tell me what is use of except clause? How it differs from not in clause?
Which tcp/ip port does the sql server run on? How can it be changed?
What are the different types of replication you can set up in sql server?
How can I check that whether automatic statistic update is enabled or not?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How does recursive cte works in sql server?
Write a sql query to sort on different column name according to the parameters passed in the function?
what is the difference between Tabular and Matrix report?
How to drop an existing table?
How to list all schemas in a database?
Does server sql treat char as a variable-length or fixed-length column?
