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
Explain the categories of stored procedure?
When would you use sql joins?
What are the properties and different types of sub-queries?
How many database files are there in sql server 2000?what are they?
List the various tools available for performance tuning?
What information is maintained within the msdb database?
What is mapping schema?
What is hot add cpu in sql server 2008?
What is enhanced database mirroring in sql server 2008?
Explain what are sparse columns?
What is xdr?
What is indexing a document?
How to get the definition of a stored procedure back?
How do I find the transaction log size in sql server?
Explain insert into select statement?
