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...

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...

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...

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...

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...

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...

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

• This reply was modified 4 years, 7 months ago by  christoph.kauflin.

thanks for the advice. I will check that.

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...

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...

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...

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...

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...

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.

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