I agree that this questions been asked many times, but it is good to have this kind of generic question because there will be new members who want to learn every little piece of SQL Server. Good question.