Hello,

I will try to answer with an single answer to all of the questions.

1. The database is not used often, the only sure thing that will run often(every day) is...

I see, I didn't know that. I will check...

About...

I don't have time to dig into this, but there is an error in the query.

LEN('L') will always equal 1, because that's how long 'L' is.

You should also remove...

We are using SQL Auth for the applications, Windows Auth for the SSMS.

Having the same user names and passwords on production and test is stupid beyond belief and violates any number of basic system controls. If you are a public company,...

Now things in your post that mildly concern me are creating new tables. Are you creating new tables from the app? If so, that feels like it MAY be...

Obvious question, why does this person have the ability to do this in prod in the first place, kill this and you resolve 99.9% of the issues

Put delete triggers...

I appreciate the perspective you've shared regarding the use of temp tables, but I'd like to offer a different view on the robust capabilities and advantages of using tempdb...

thx Martin

i have to ask why tempdb is singled out in your post as a problem.  Wouldnt each server's instance be managing its own tempdb within the confines of...

A little stupid question by me, I am new into SQL Server, but if the tables are empty after truncate, the statistics should be finished in probably less than a...

As someone who used temp table and had a lot of issues with it, I highly recommend start creating table into DB and use it.

TempDB is good only if you...

From the conversation it sounds like the OP has a string field that is actually holding multuiple pieces of information.  The issue here is actually one of poor database...

this is a rather incorrect assumption and can be easily proven to be wrong.

SQL Server will ALWAYs compare the whole contents with exception of trailing spaces which are ignored...

• This reply was modified 8 months, 1 week ago by  Martass.

Using a function on a column generally stops it being SARGABLE. (ie It will not be able to use any indexes.)

You should use:

AND CDHDR_NEW.OBJECTID LIKE MM_EKKO_STAGING.EBELN...