What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning
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
Explain about link server in sql server?
How is sql used in sql server?
Why use update_statistics command in sql server?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What are sql dirty pages?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
what are constraints? Explain different types of constraints? : Sql server database administration
How to download and install the scaled-down database adventureworkslt?
Can you explain different types of locks in sql server?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is self contained sub query?
What are different types of statements that are supported by sql?
Explain the microsoft sql server delete command? : SQL Server Architecture
What are the different Authentication modes in SQL Server and how can you change authentication mode?
Explain the rules for designing files and file groups in sql server?