How to change date format at SQL Server?

How to change date format at MS SQL Server?

SET DATEFORMAT DMY


Note: DMY means Day-Month-Year, so you can use MDY or YDM, etc...