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
How are the unique and primary key constraints different?
Do you know what is rank function?
What is openrowset sql server?
How to reaname table name without using sp_Rename in sql server..?
How to apply filtering criteria at group level with the having clause in ms sql server?
What is a derived table?
How do I delete a sql server database?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Why truncate is ddl command?
what is the maximum size of a row? : Sql server database administration
why would you use sql agent? : Sql server database administration
How to create a user name in a database?
Differentiate between ms sql server reporting services vs crystal reports?
What is logshipping and its purpose?
What is cursors?
