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
Do you know what are the restrictions that views have to follow?
What information is maintained within the msdb database?
What is a Join and explain its types?
What are the differences between union, intersect, and minus operators?
What languages bi uses to achieve the goal?
In what sequence sql statement is processed?
Explain the advantages of merge replication?
What does null mean?
How to connect php with different port numbers?
What is clustered vs nonclustered index?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How is sql server used?
How can you control the amount of free space in your index pages?
How to generate create procedure script on an existing stored procedure?
How to deploy the Report?
