Personally I see DateTime & DateTime2 as different Data Types and therefore shouldn't be compared to each other in the first place.

One of these should have been converted to the...

Thanks for the Question. I figured it out by the fact that the questions were concentrating on 1949-1950.

I also use a version of DB2 which uses a Cutoff of 1940...

My first encounter with a Computer was an IBM 1130, I was a student at a nearby College and the Computer was at the University. We went there one night...

Are we really going to replace Desktops with Tablets ? I think of the millions of workers using Keyboards as their interface to the Business world and their ability to...

I'm hoping that the SQL Server evolution will lead to less Performance Tuning by the DBA. Surely everything that a DBA can determine about the performance of a Database Engine...

I began with SQL server 4.2, I was working for a small Services Company trying to establish themselves. My Boss was convinced by Microsoft that we should become a Microsoft...

C. This was my first encounter with uninitialised variables.

When I declare an Integer for example I expect its value to be 0.

At least in T-SQL we can now give...

I got caught by the Null. I work as a Programmer more often than not where some Languages automatically initialise a Variable at declaration time. The ones that don't tend...

Bit late to the party but my 2c worth.

Decided to go full 64 bit with SQL Server 2008 R2, Server R2 & Windows 7 64 bit.

I had trouble with Office...

I still don't get why people when talking about Dates include a Time Component. Dates are Dates and Time is Time. We have had Date & Time Data Types for...

I'm happy that we're starting to get questions with the more modern Data Types. Datetime should have been retired when Date, Time and DateTime2 were made available.

David

Thanks. I enjoyed this question. Had to think about the '' but got there in the end.

I hate the DATETIME Data type. A lot of these questions wouldn't be necessary if DateTime usage was replaced by Data Types: DATE, TIME & DATETIME2

The sooner we stop using datetime the better. We now have Date & Time Data Types and DateTime2.

It's fairly straight forward: Dates and Times should be stored as such....

My Vote is for Spaces.

As previously mentioned there is no consistency in the interpretation of Tabs. I've seen 2, 4 & 8 Spaces.

Spaces are portable whereas Tabs are IDE specific.

I...