Understanding SQL Server Datetime columns - Part I

There are N number of questions asked in the forums about handling dates in query Most of the people who ask questions dont understand how datetime column works in SQL Server Some of the questions frequently asked are about 1 using dates in the WHERE caluse 2 formatting dates using SQL 3 inserting dates to the table with specific date format etc