Forum Replies Created

Viewing 15 posts - 211 through 225 (of 315 total)

  • RE: Issue updating columns for existing rows

    Hi Patrick,

    unfortunately it's not that easy it seems :crying:

    Msg 8115, Level 16, State 2, Line 2
    Arithmetic overflow error converting expression to data type datetime.

  • RE: Dealing with Technical Debt

    I (as I'm the only one here doing BI things) have a very basic measurement about Technical Debt:
    Once existing applications exceed their target runtime, it's time to revisit the...

  • RE: Common Data Challenges

    I'm not in the business as long as you are Steve - roughly 1/3rd of your time - and I only very recently started to care about data outside Performance...

  • RE: The Android Car

    AnOldAmigaUser - Monday, March 4, 2019 1:49 PM

    The car companies want to get in the data collection business as much as Google...

  • RE: The Android Car

    I think drive-by-wire (wether it's brake, accelerate or steer does not matter) has nothing to do with this discussion, but to mention it for the sake of discussion: Sensor lag...

  • RE: Definition of minor version numbers

    one represents the SQL Server Version and the other defines the file version so your SP information only applies to the file version not SQL Server Version.

    Maybe...

  • RE: Full-Text Search Not Updating

    so, what does the latest crawl log at the very end state why it didn't finish yet?

     I have seen cases where AAGs with FTS on DBs did not...

  • RE: The Android Car

    My suggestion would be to get in touch with Syvecs / Bosch for an S6 / MS 6.4 ECU or something like this, depending on the car I guess ;-)...

  • RE: What happens exactly to Non Clustered Indexes when you truncate a table?

    Hi Steve,

    I think what you say makes sense, that's why I came to the conclusion a fast load makes sense once, however during the last load we went...

  • RE: What happens exactly to Non Clustered Indexes when you truncate a table?

    My working theory is by the way: We had a much faster load last night because those unused indexes did only exist as definitions during the first run while during...

  • RE: CASE with LEN Evaluation

    Dear thank you everyone who's participating.

    First I want to say I also had potential leading / trailing spaces in suspicion as the base data type was nchar(8) but...

  • RE: CASE with LEN Evaluation

    I do have still troubles, as far as I see he can't evaluate properly for some reason,

     I mainly see LEN ==6 values off like: '2000190116' which should be...

  • RE: CASE with LEN Evaluation

    there is not much of a DDL to post here, it's a nchar(8) field and it stores either:

    0, 200, or some 3 - 6 String length combinations of...

  • RE: Reserved Space

    *Waiting on Quantum Storage* 
    *Reality kicks in*
    Meanwhile your Cloud Provider charges you by the GB and IOPS.

  • RE: Conditional Split and Expressions issue

    I'm not sure if in this case going for a stored procedure would be any better as for me that sounds even more complicated to me, or well at least...

Viewing 15 posts - 211 through 225 (of 315 total)