6 Jobs AI will never do

1. CEO
2. CFO
3. CTO
4. CIO
5. Senator
6. Public Representative

Those who make decisions about the implementation of AI don't have to worry about losing their jobs to...

If I have several date columns in a fact table (say, date of entry & date of booking), should I create one dimension date table per date column or is...

I miss the SQL Server MCP exams. They were good at...

How does multi-instance mode for Analysis Server work?

I installed a default instance & a named instance and the mode is either one or the other. I can't get the server...

I have three.

1. This first is a quote, which I think is from Oscar Wilde: Know something about everything and everything about something;
2. The second is from an ad I...

Why plan on only jumping all the way to 2022? It seems that 2019 is pretty stable now and they may be done implementing breaking updates - there have...

• This reply was modified 1 year, 5 months ago by  sean redmond.

@sean-redmond, thanks for the reply. I couldn't agree more. Asking is usually the best path forward. It builds relationship and helps others see where the shortcomings in knowledge sharing...

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 1 year, 6 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...