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
- 9925 Views
- TCS, I also Faced
- E-Mail Answers
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
How to choose all records from the table?
What new data source types were added in ssrs 2014?
What language is sql server written in?
Does table partitioning improve performance?
Explain “row_number()” in sql server with an example?
What do you understand by hotfixes and patches in sql server?
What is deploy, process and build? : sql server analysis services, ssas
What is unique key constraint?
What is GUID in sql server?
What is a result set object returned by odbc_exec()?
Explain how to integrate the ssrs reports in application?
What is the use of for clause?
What command is used to rename the database?
What is reference section?
What are the differences between clustered and non-clustered index?
