Hi @mark-3,

my concern here is that this exercise will render the data nonsensical and ambiguous.

😎

This free text approach is YASA, yet another SQL antipattern, a better approach is...

Thank you @Sukhdevsinh for this writeup!

😎

Now my question is; Why would you like to concatenate multiple values into a single value? I consider that as an antipattern that should be...

The image data type should be avoided, no real benefit over modern binary data types.

😎

The image data type can only be converted to binary, varbinary and interestingly enough timestamp. The...

Thank you Shivayan for this nice write-up, now I'm interested in how this scales in cost and capacity compared to other solutions. Any thoughts?

😎

And...

No but I have raised this kind of risks several times in the passed in assessments.

😎

If software is operating...

Just as peanuts are not nuts, they are legumes, peanuts do not have exocarp, mesocarp, and endocarp, phone numbers are not numbers. Phone numbers are not mathematical objects as phone...

Would anyone be prepared to help me with a few (seemingly) simple DAX questions?

I've been reading up and searching for answers, but can't seem to find the right way...

A quick thought, let's figure out what needs to be done before pondering on how things are done!

😎

A simple modelling of the problem would include the following entities:

            
June 20, 2024 at 3:38 pm
            
#4430059

            
            
                                                
        

.-. --- ..-. .-..

😎

Hi Pieter,

can you share the model you are working on?

😎

There are several ways of approaching this problem, some are good, some are bad and some are ugly!

For performance, one might...

Do you have the supporting foreign key constraints in place?

😎

If the table joins are supported by foreign key constraints with the proper indices, the engine can "trust" the statistics instead...

Reaping the benefits of the Window functions in T-SQL – SQLServerCentral

😎

Look at the second...

If you can send a note to marketing@ with your specific complaints or issues, that will help. There is a proposal up with our internal IT staff/developers to do...

Happy to help, now let's dig into the problem you need to solve!

😎

Could you please list the high-level requirements in a handful of bullet points?