Forum Replies Created

Viewing 15 posts - 1 through 15 (of 22 total)

  • Reply To: CONCATE_WS Not Recognizable

    Thanks, my bad. I am a little embarrassed. I somehow misread and had 2012 or 2008 in the back of my mind. But I also think that the tool-tip when...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: CONCATE_WS Not Recognizable

    I have the same problem, but I am on  Microsoft SQL Server 2016 (SP2-CU12) ...   when I hover over it, it also says "built-in function" , but the errror message...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: MacOs User connection to SQL Server from Excel

    Yes, they can login in to windows shares, but it seems to be buggy, and they use Kerberos.

    The support from the IT -Department was not very enthusiastic, so I gave...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: MacOs User connection to SQL Server from Excel

    Thanks, I will check the link, but as I remember we were on the step of selecting the user, which we don't have to for windows user, because there it...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Saving integers as varchar so that I can choose '' (empty) as content

    I'm curious as to why any row in an Employee table would ever have a NULL (or a -1 alternative or an "empty" alternative) for the Employee number for any...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Saving integers as varchar so that I can choose '' (empty) as content

    I must check, but as I remember from my own experience if there are strings, empty strings and null values, I have to query for empty or null to find...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Saving integers as varchar so that I can choose '' (empty) as content

    I thought queries and joins are easier if there are no null values in the joined fields?

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Optimizing view and Table

    thanks for the advice. I will check that.

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Optimizing view and Table

    I am so happy: I have shrunk the table to half its size. And I am frustrated, because I had different collations on my local server...  so I learned to...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Optimizing view and Table

    My IT is quite strict and they wouldn't install developer edition because of licensing reasons, but as you say, it is not a production machine. Maybe I will install it...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Optimizing view and Table

    I don't know about the backups, this concerns (only) my db-Admin. He restored some dbs, so that seems to work 😉

    but when I copy a big chunk of data, sometimes...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Optimizing view and Table

    Thanks (to all) for the advice and links. This seems to be helpful too.

    Yes, one reason is space. Our database-administrator is really being difficult about the amount of space...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Optimizing view and Table

    No it is the standard edition.

    Usually we need two years, the current one (which still is 2019 right now) and the next one (2020) for Budget. Currently I am changing...

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Optimizing view and Table

    No, it is the size of the Table on SQL-Server, when I check the report Disk Usage by top tables. Excel is only 80 MB.

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

  • Reply To: Execute a procedure with parameter from table, one by one

    thanks. looks good. I will look into this soon.

    Christoph Kauflin
    working in Controlling, but trying to program the tools we need to do that

Viewing 15 posts - 1 through 15 (of 22 total)