Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Observed that some SP’s / Jobs are processing late, how to
troubleshoot to improve performance?

Question Posted / sandeep


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

Post New Answer

More SQL Server Interview Questions

How to return the second 5 rows in ms sql server?

0 Answers  

How is sql used in sql server?

0 Answers  

How do I view views in sql server?

0 Answers  

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

Can sql server be linked with other servers like oracle?

0 Answers  

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

What is normalization and its forms?

4 Answers   Challenger Financial,

How to check if a table is being used in sql server?

0 Answers  

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

What is it unwise to create wide clustered index keys?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories