Would you put your heap table name in the code below, run it, and post the results?  That will help determine which, if any, index is best for a clustering...

Yes, you could use a JOIN.

SELECT IL.Item,ForecastDemandQty,ForecastDemandMAD,MinShelfQty,MaxShelfQty,
QuantityOnHand,QuantityCommitted,QuantityAllocated,QuantityReleased,ExcludeFromDistraNet,
ITH.TotalShipped

FROM tblimItemLoc IL

LEFT OUTER JOIN (
    SELECT Item,SUM(TxQty) AS 'TotalShipped'
    FROM IMInvTxHistory
   ...

Here's the TIME statistics for:

SELECT TOP (200) DATALENGTH(varbinmax_col1)

(200 rows affected)

SQL Server Execution Times:

CPU time = 16 ms, elapsed time...

Yeah, the SELECT ... INTO holds certain internal locks on system tables.

Instead, create the table, the clus index (only), and only then load the data into it, like this:

            
April 27, 2021 at 5:02 pm
            
#3876405

            
            
                                                
        

I would think using the EXEC ... AT method, should get around that.  Try that:

EXEC('SELECT ... FROM dbname.dbo.table_name ... WHERE ...') AT [RemoteServer]

n/a

Evening Guys,

(1) Are there negative effects of having multiple stored procs wrapped in an outer/master proc?

(2) Will the inner procs that are executed all be run as one...

Shifting gears to the code itself, it's pretty much a both a resource and performance nightmare.  It makes one full pass of either the CI or an NCI for...

Deadlocks would be one of the main ones, I would think.

This query or one just like it seems to come up a lot.  But I still don't know if there's enough demand for, say, a full article on it.  It's...

I asked because many people are happy with code as long as it ultimately does what they need it to do, i.e. "the code's good enough for me."  In that...

What are you asking why instead of posting a link to...

Hi,

I get the object id, it stopped working when I updated the management studio, i think it is not the code, but rather a new thing...

Btw, why are you using such an inefficient method, checking the column values one by one?

Please do some research and look up the E you rules for triangulation. This means that you have to convert from currency A to Euros, then from Euros to currency...