Sometimes the Simplest Solution Isn’t the Best Solution (The Optional Parameter Problem)

Programmers should naturally gravitate toward the simplest, most elegant solution.  This is because the simplest coding solution is so often the best solution: simple solutions are cheaper to implement; easier for others to understand, maintain, and extend; and less prone to bugs.  Simplicity can also be associated with efficient and consistent execution, but performance is…

11

The Death of DateTime?

SQL Server 2008 added a new data type named “datetimeoffset”.  This is similar to the old datetime data type, with the following significant differences: ·         Internally, the time is stored in unambiguous UTC format ·         The local time zone offset is stored along with the UTC time, which allows the time to be displayed as…

5