Agreed but, let me ask... do you have any tables where they have a separate DATE and TIME column and it sometimes needs to be recombined into a DATETIME2...

Thank you everyone for your feedback.

As I am sure you are aware, extensive testing, including stress testing, is key to any migration. Personally I would be loathed to put...

'A common people, divided by a common language...' (to paraphrase W. Churchill, quite possibly quoting someone else)

I noticed this in Japan when I was there on the JET Programme. I...

The answer lies in a matter of...

Fair enough.

The

The rounding up of the last 30 seconds to the next hour is not a problem. ... And as for space, if we have 100GB of data, then...

• This reply was modified 3 years, 2 months ago by sean redmond.

Thank you all.

The consensus is that it is just not worth it. I hadn't planned on doing any extra work other than changing the default datatype. It is simply a...

Hi Scott,

I'm not that worried about space per se. The column will be one of metadata and while seconds would be nice to have, accuracy to hours & minutes is...

I think that this is a subtle hint from Microsoft that you should be using Azure and not SQL Server. Or PostgreSQL.

It is very sloppy & unprofessional.

Dirceu Resende has a...

This is so true.

How many of us look forward to finding a secondhand bookshop with old Kindle titles in it? With any luck, some brave person will have amassed a...

SJ» Hard disks and tape changers seem to be fading, though I'm sure someone still uses them. Anyone bought a tape drive for their personal or business use anytime in...

There are "mvps" and then there are MVPs.  People forget that the MVP award is, just that, an award.  It is NOT a certificate of knowledge, skill, or ability. ...

As far as I see it, there are two points here: how much of an expert on the topic in question the presenter is and to what extent is the...

roger.plowman» and I have to say I hope Sean Redmond is being facetious.

I wish I were. I am just angry. I completely agree with you.

Still, I'm learning tabular models to...

DBA cynicism

Developers don't need to know SQL, they only need to know Entity Framework or some other ORM.

ORMs allow them to ship code faster and that is their sole criterion....