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
- 9748 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
How many types of local tables are there in sql server?
What are different types of raid levels?
What is a View ? Can we insert, Update and delete a view?
What is after dml trigger?
What is the difference between ddl and dml?
How do I find information about the install locations for the various instances running on a computer?
What does dml stand for?
What are the tools available in market as an alternative to sql server reporting services?
what is datawarehouse?
How you can minimize the deadlock situation?
what is a transaction? : Sql server database administration
How to define the name and server for a new dsn?
What is data compression? : sql server database administration
What is a bit datatype?
How to defragment indexes with alter index ... Reorganize?
