I know , it's kind of DBA questions and they are excepting the Developer to answer it and I am a Newbie to SQL server ,and never faced such situations in realtime enviornment.