I can't see the full SQL query text. Can you paste the full query in this thread?

Also, how many rows are on EDW.dbo.DimInvoice?

I think these 3 queries will do the same thing

SELECT t1.CATEGORY, t1.ITEMID 
  FROM ecomm.Promo_Items t1
 CROSS APPLY (SELECT NESTEDSETLEFT, 
     ...

I've had to vertically split a dimension table on a data warehouse. It had over 500 columns, almost any update was causing a page split so splitting the table into...

You can use MAXDOP on an individual query e.g.

SELECT ProductID, OrderQty, SUM(LineTotal) AS Total  
FROM Sales.SalesOrderDetail  
WHERE UnitPrice < $5.00  
GROUP BY ProductID, OrderQty...

It doesn't sound like a memory issue, but if you are sure it is you could reduce the memory SQL Server uses just before the SSIS packages run...

It doesn't sound like a memory issue, but if you are sure it is you could reduce the memory SQL Server uses just before the SSIS packages run and increase...

It's a very good idea to put all your stored procedures and other database code in source control. One file for each SP.

If you don't want the rows with the NULL's to be returned just make it CROSS APPLY instead of OUTER APPLY.

If you want the rows with the NULLS to be...

DECLARE @title as VARCHAR(MAX) = 'Title:';

SELECT si.ItemID,
       si.Code as SKU, 
       si.AnalysisCode12 as MSKU,
 ...

I'm not sure if I understand what you want. Do you want to find all rows in the master table that have rows in all the other 50 related table?

If...

Compression to save disk space is of dubious value unless it saves IO.

With technologies such as Fusion-IO and SSDs where you are talking about literally thousands of times that...

How do you want the 30 second intervals defined?

i.e. do you want them divided into clock-face 30 second intervals or for the 30 second interval to start at the time...

Why did you delete the text in your original post?  Even if it turned out to be a dumb question that you found the answer to, a followup...

You could create a daily agent job with a separate step for each (monthly/weekly/daily) task then add a step to the front of each of those steps to test if...

I think if you format the values in your table correctly you should be able to do it without a cursor or using dynamic SQL by using

"CROSS APPLY OpenRowset(..."