Not to be rude, but you are asking us to teach you everything there is to know about SQL Server, A-Z.....
How about enrolling in a course to get you started? or start studying towards 70-432 MCTS Certification?
You can view the workings and areas of SQL Server here: http://msdn.microsoft.com/en-us/library/ms130214.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle