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 to define testing of network layers? : Sql server database administration
What is the difference between substr and charindex in the sql server?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
When you should use a low fill factor?
How to deploy the Report?
What are the steps to process a single select statement?
How to use “drop” keyword in sql server and give an example?
What is sql server replication? : sql server replication
What is ssl in sql server?
What is @@rowcount in sql?
Working with TLogs
Explain about link server in sql server?
Can you insert NULL in unique column?
How to configure odbc dsn with different port numbers?
What is normalization and what are the advantages of it?
