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 to delete all rows with truncate table statement in ms sql server?
What is policy management?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Define union, union all, minus, intersect?
How to check status of stored procedure in sql server?
What happens on checkpoint?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is the difference between NOROW and LOCKROW?
Explain the cursor lock types?
What are the operating modes in which database mirroring runs?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Delete duplicate rows without using rowid.
what are cursors? : Sql server database administration
How to delete duplicate rows?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
