Interested to Buy Any Domain ? << Click Here >> for more details...
What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning
- 3 Answers
- 10058 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / parmanand
Agree with John, Just to add this is a way to make our query
fast and to reduce the over load on server.
The RECOMPILE option
SET NOCOUNT ON/OFF
Creating Indexes on tables are few points to fine tune our
query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the synonym of join?
Explain what is raid and what are different types of raid levels?
Do you know the cursor optimization tips?
Why use “nolock” in sql server?
Explain a checkpoint?
What is collation?
Where do you find the default Index fill factor and how to change it?
How to find related tables in sql server?
How do I get to sql server configuration manager?
How to modify an existing stored procedure in ms sql server?
Can group functions be mixed with non-group selection fields in ms sql server?
what authentication modes does sql server support? : Sql server database administration
What is resultset concur_updatable?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is the main purpose of having conversation group?
