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
What do you know about normalization and de- normalization?
What is an identity column in insert statements?
What are the main sources of data?
What is the native system stored procedure to execute a command against all databases?
How to convert a unicode strings to non-unicode strings?
Tell me what is difference between clustered and non clustered index?
What happens to a statement batch if there is a compilation error?
How is foreign key related to primary key?
Detail about query optimizer?
What command would you use to add a column to a table in sql server?
What are relationships and mention different types of relationships in the dbms
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is checkpoint process in the sql server?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is a partition key?
