• frederico_fonseca - Monday, March 19, 2018 7:07 PM

    When loading the data onto Powerbi split the datetime fields onto date portion and time portion as separate columns.

    The big int fields should also, where possible, be split
    e.g. a number

    123,123,123,122 could be split onto 3

    Never a good idea.
    If a package assumes it as a good practice the best approach would be not to use it.

    can you write a query to select all queries started during off-hours last night?
    And what about a query selecting all events with writes > certain amount?

    With split columns both queries would require table scans, which means reading the whole table into memory and apply filtering in there.
    Which is exactly the problem with the current state of affairs in OP's database.

    _____________
    Code for TallyGenerator