There is no such thing of any kind built into SQL Server.

If you just want to get rid of all digits in the email address, then:

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(email_id, '0', ''), '1', ''), '2', ''), '3', ''), ...

Most likely, SQL detected that fewer rows would be returned and therefore changed how it would access those tables based on row estimates.  If the row estimates are off, SQL...

You need to look at your stand-alone (non-proc) query again.  It seems to have an INNER JOIN rather than a LEFT JOIN, at least according to the query plan.

Maybe it will.  SQL can pre-fetch data.  It depends on the specifics of the situation, including your edition of SQL Server.

Since TRUNCATE is more efficient, try it first.

If it doesn't work, then use DELETE.

STRING_AGG isn't available before SQL 2016, right?

Select T1.Itemcode,T1.name ,
    stuff((select ', ' + docno 
        from [order]...

Rather than a CASE, use the built-in REPLICATE function:

DECLARE @MAX_naam AS varchar(MAX) 
SET @MAX_naam = 22 --(SELECT SUBSTRING(MAX(naam),LEN(MAX(naam))-1,LEN(MAX(naam))) FROM incident); -- = 22
DECLARE @maxnaam_length AS int =...

Ah, but this is a SQL Server forum.  Your q is somewhat off-topic here.  You might want to...

Right, because reorganize only ever needs 1 extra work page, the in_tempdb option is really meaningless for reorg.

SELECT SubmissionGuid
FROM #Subs
GROUP BY SubmissionGuid
HAVING MAX(CASE WHEN QuoteStatus = 1 THEN 1 ELSE 0 END) = 0

To avoid using the user db for index rebuild work space, look into specifying SORT_IN_TEMPDB = ON as part of the index REBUILD.  This is especially true if you have...

I'll assume you have an existing clustered index on the table.  If you do, most likely you'll want to use a clustered columnstore index instead.  To do that, follow these...

For best performance, make sure you have the log table properly clustered.  Specifically, if you intend to delete by log time, as is quite typical, then cluster the table that...

Rather than adding a month and taking away a day to  get the end of month (which is how I have always done it) there is a function called...