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
- 9874 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
What are the filtered indexes?
How to delete duplicate rows?
What is the process of normalising?
Difference between Logical Page and Physical Page in SSRS.
What is wrong with sql server client libarary dll, ntwdblib.dll?
Can you index views?
What is difference between delete and truncate commands?
List some major differences between triggers and stored procedures?
What is a transactions?
How to create a large table with random data for index testing in ms sql server?
Is truncate autocommit?
Explain what is row_number function?
What are the different types of normalization?
Can we take the full database backup in log shipping?
What is cte (common table expression)?
