Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / arindam choudhury
suppose the query is correct in astored procedure then
1)we need to use tablename with (nolock) in our select
statements so that it does not create delay if other person
is updating the table at the same time it will show last
updated table recordset
2)if we dont need that much the database server to return
the number of records affected after executing any dml
statements which actually reduces the performance ,we can
use set nocount on -set nocount off before and after
writing the sql query,
3)wecan create lesser join statements if we can use
subqueries
these are the few steps to tune stored procedure
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Should you normalize audio?
What is the recovery model? List the types of recovery model available in sql server?
What methods do you follow to protect from sql injection attack?
What is report snapshot?
Can you tell me about the concept of ER diagrams?
How to list all stored procedures in the current database using ms sql server?
Explain where clause?
Is sql different from sql server?
Explain indexed views and partitioned view with their syntax.
Can binary strings be used in arithmetical operations?
How do you start single user mode in clustered installations?
How to create new table with "create table" statements?
Explain the creation and execution of a user-defined function in the sql server?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
what's the difference between a primary key and a unique key? : Sql server database administration
