komal145 (12/4/2012)
Hi..I had an interview and had few questions:Can anyone please help me finding out answers for the below questions?
1) Design table to track phone?
It totally deppends on the business requirements means what data they want to store.
2) how to troubleshoot high volume data?
3)How to identify performance issues.
4)Which statement is running slow, how to find it.
5) How to Optimize stored procedures ?
For above question as Sean suggested these are topic for discussion and you can find out lot of articles on little google search.
6)Suppose I hv 3 SP. SP A, SP B and SP C. SP A calls SP B and SP B calls SP C. If there is a problem with SP C then how we gonna use TRY and CATCH?
Thanks,
komal
May be I did not understand the question because what does mean how to use TRY and CATCH or what is the relation of having child procs with TRY-CATCH.