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
- 9938 Views
- TCS, I also Faced
- E-Mail Answers
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
What is difference between primary key and foreign key?
How to bind a view to the schema of the underlying tables?
Do you know the different ddl commands in sql?
can a database be shrunk with users active? : Sql server administration
Can we use pragma autonomous_transaction in trigger?
What types of Joins are possible with Sql Server?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is the stuff?
How do I uninstall sql server 2014?
What function does a database engine serve in the sql server?
Can you explain important index characteristics?
How do you manipulate data?
What is CTE in SQL
What is difference between drop truncate and delete?
What are ddl (data definition language) statements for tables in ms sql server?
