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
- 10050 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 advantages of using a stored procedure?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
Give the query of getting last two records from the table in SQL SERVER?
How to enforce security in sql server? : sql server security
What Are the Main Features of SQL Azure?
How to change the password of a login name in ms sql server?
What are the various editions of sql server 2017 that are available in the market?
What is index, cluster index and nonclustered index?
What is the default sql server instance name?
What are the different authentication modes in sql server?
Can foreign key be duplicate?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
How to create an index on an existing table in ms sql server?
What is "scheduled jobs" or "scheduled tasks"?
what is nonclustered index
