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
- 9873 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 collation sensitivity?
What do you mean by data manipulation language?
What are scalar functions in sql?
Which language rdl files made of?
What is the most common trace flags used with sql server?
What is SQL Azure Fabric?
What is ms sql server index?
What do you mean by cardinality?
What is history table in sql server?
Where is my database stored on the hard disk in ms sql server?
How to write a query with an inner join in ms sql server?
What are points to remember while using the fillfactor argument?
How fixed length strings are truncated and padded?
What factors you will consider calculating the storage requirement for that view?
Explain the use of containers in ssis?
