I suggest creating the following indexes to support the query.  If you'd like to adjust other indexes on the tables also, just let me know.

CREATE UNIQUE...

Can you please run this

SELECT TOP 10 item_no, loc, COUNT(*) NN
FROM IMLSMST_SQL
GROUP BY item_no, loc
HAVING COUNT(*) > 1
ORDER BY NN DESC

and post here the outcome?

• This reply was modified 4 years, 10 months ago by Sergiy.

How many rows returned by

SELECT IMLSMST_SQL.ser_lot_no
FROM IMLSMST_SQL
WHERE IMLSMST_SQL.loc = '@@LOC'
AND IMLSMST_SQL.bin_no = '@@BIN'
AND IMLSMST_SQL.item_no = '@@ITEMNO'

?

Is column wsPKG.STATUS nullable?

Almost correct. Except the order of dates:

declare @Today datetime;
set @Today = '20210719';

SELECT MyTable.ExpiredDate
, DATEDIFF(dd, @Today, MyTable.ExpiredDate) DaysLeft
FROM (VALUES
('2021-07-25 15:29:09.000')
,('2021-07-28 17:31:22.000')
,('2021-07-19...

The query is obviously built by some automated tool and has to be fixed.

unless there is some special logic which is not apparent from the first glance.

DATEDIFF(did, ..., ...) should do.

You're misunderstanding me.  Getting all the requirements...

Steve, if you learned that getting all requirements upfront does not work - why do you stand by this approach in jobs?

The rule of thumb here is simple.

a responsible person would not apply for a position with a long list of random requirements. Because he/she does not possess the required skills...

Update Cars

Set Cars Club=Replace(Cars Club,'Holden','GM') and City=Adelaide

where Cars Club like ‘Holden’

and not (Cars Club like '%Elizabeth Holden%' or Cars Club like 'Holden Elizabeth')

Did you correct the spelling mistake in Adi’s script?

Holde[nm]

Another thing I was never able to understand - why index tuning is a job for ops?

they are definitely a part of table design, and changes to it should go...

People forget that DevOps is about building a culture of collaboration between people with different disciplines.  It is not a bunch of technologies, buzzword bingo or fancy job...

I wish...

How many ads did you actually see?

How many of them passed reality check?

Any?