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 / john
PERFORMANCE TUNING:
Shortly : The performance tuning is reduce the load of the
database.
stored procedure:
--create a sample performance tuning procedure
CREATE PROCEDURE dbo.spTestDelegator (@query bit) AS
BEGIN
--NOCOUNT is use to reduce the load
--if its off the procedure get (full memory) of execution
SET NOCOUNT ON;
IF @query = 0
EXEC spTestFromAuthors
ELSE
EXEC spTestFromPublishers
GO
CREATE PROCEDURE dbo.spTestFromAuthors AS
SELECT * FROM authors
GO
CREATE PROCEDURE dbo.spTestFromPublishers AS
SELECT * FROM publishers
GO
STEPS:
1.Good code ideas
2.Reduces use more query in same procedure
3.use clear structure of code
4.always done stored procedure is good. because,Transact-Sql
get load of execution
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the difference between a "where" clause and a "having" clause?
How to list all dsn entries on your local machine using odbc_data_source()?
How can you hide the sql server instances?
Explain steps of normalization?
How much does sql server 2016 cost?
How to disable stored procedure sql server?
what is the difference between Delete and Truncate command in SQL
How to select all columns of all rows from a table with a select statement in ms sql server?
What is the difference between ‘having’ clause and a ‘where’ clause?
What are the differences between substr and charindex in sql server.
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is the definition for sql server 2000?
What is normalization of database?
What do you know about system database? : SQL Server Architecture
What is difference between rownum and row_number?