Observed that some SP’s / Jobs are processing late, how to
troubleshoot to improve performance?
Answer / neetu
U have to optimize SP for that
1. Use as much as possible WHERE clause filters. Where
Clause is the most important part for optimization
2. Select only those fields which really require.
3. Joins are expensive in terms of time. Make sure that use
all the keys that relate the two tables together and don't
join to unused tables, always try to join on indexed fields.
The join type is important as well (INNER, OUTER).
Is This Answer Correct ? | 3 Yes | 0 No |
How to handle error or exception in sql?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
Define the term DML, DDL and DTL?
Do you know what are acid properties?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is inline variable assignment?
explain the type of contraints
Can we insert data into view sql server?
When would you use the stored procedures or functions?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Explain about SQLOS?
Is it possible to create tables in stored procedures using a variable for the table name?