I’ve this desk:
create desk Translations ( -- major key, TranslatorId bigint, TextId bigint, TextLengthInWords int, -- different fields SavedDateTime datetime )
Translators are given a whole lot of small texts (paragraphs of various sizes) and so they begin translating them of their private schedule, and due to the corporate’s insurance policies, they will not be paid based mostly on phrases depend. Slightly, fee ought to be performed based mostly on the quantity of labor in hours.
This creates a supervision want. That’s to seek out translators, who should not reliable. What’s the definition of trustworthiness? Being dedicated to the mutual contract. Translators agreed to work for x hours a day, regardless of how a lot they translate. They need to translate with out stress, however on the identical time with out being free and lazy.
Now we wish to someway visualize
SavedDateTime based mostly on the textual content size. We do not know when a translator has began to translate a paragraph, however we all know when he has pushed the save button.
Additionally we all know that translators normally translate for one or two hours, after which do different duties, then come again to translation and it is uncommon that they translate just one paragraph after which go after which come again. Thus the beginning datetime for lots of information is the
SavedDateTime of the earlier document.
Do we now have instruments in SQL Server to visualise datetime columns? For instance, I do know I can choose information, and interpret them utilizing grid view. However that is 100% handbook, very inaccurate, costly and inefficient. I am on the lookout for different outputs.
The necessity is: to seek out out good translators and dangerous translators
P.S. please do not recommendation on firm’s coverage. As an alternative, assist me visualize this timing.