Hmm, I wouldn't think there'd be a direct money charge just from having to reread something into RAM.  Then again, that could change by vendor I guess (we use MS).

But...

/*INSERT INTO dbo.input_Main_data ( ... )*/
SELECT new_rows.*
FROM dbo.input_Main_data iMd1 
CROSS APPLY (
    SELECT TOP (1) *
    FROM dbo.input_Main_data iMd2
  ...

Yes, I...

I see the big issue as one of less RAM.  I suspect the max ram you receive will be far less than what you'd get in an on-premises db.

When fragmentation...

Here's a method I often use.  "Ideal", don't know.

Use full backups and differentials.  Generally a differential restores very quickly (you can do the "base" restore of the full backup ahead...

If hyperthreading is present (most CPUs use this nowadays), set MAXDOP to no more than half the cores, in your case 4.

If NUMA is being used, set it to no...

SQL row/page compression is typically extremely helpful to reduce disk space.  Before SQL 2016, I believe you must have Enterprise Edition for it to be available.

In the main table storage area, a row will be on one and only one page.  Any other data for that row must go to overflow pages.

-1- There's not an...

You could try making the data type "rowversion" or "binary(8)" just to see if it works.

Agreed, the best thing would be to review the query plan.  Even the estimated might give you some idea of the differences between the two queries.  To get the actual...

@ScottPetcher

This is a READ COMMITTED transaction.  The lock should only be held for the duration of the statement, not the entire transaction.  So that doesn't seem to answer why...

SQL probably takes the key lock before / as it's reading the row.  SQL's not taking a lock on a "row that doesn't exist", it's taking a lock on the...

• This reply was modified 5 years, 2 months ago by ScottPletcher.

Hmm.

Presumably if SQL Server lets you alter the data type, then I would think the index should be good to go?!

Every db on an instance is upgraded internally to the current SQL version.  A backward compatibility level only affects certain things, not absolutely everything.  Thus, yes, it's possible that a...

I don't have time to attempt to consolidate the ExportSignal lookups right now.

SELECT

ISNULL(STA.STA_Manufacturer_Code, RDD.rdd_5) as 'Manufacturer Code',

(

SELECT TOP (1) ID2.Content FROM ItemMaster IM

join ItemMasterDetail ID1 on IM.Id...