The value specified by this option affects the result of the DATEPART function when obtaining a weekday value. You can also
change the first day of week using the DATEFIRST option in the SET statement.
The value specified by this option does not affect the result of the DOW function. For example, even if the first day of the
week is set to Monday, the DOW function returns a 2 for Monday.