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(..."

You need to look at the SQL calls being made to the database. It's impossible to diagnose your performance problems by just telling us you have a database job that's...

I think Jeff is correct. There will be one or more tables that have foreign keys referencing the able you are trying to delete from. These tables won't have indexes...

It's a bit of a long winded way to write that query. You could write it like this:

    SELECT 1     ...

Does this do what you want?

select * 
  from #duplicatesample a
  left join #duplicatesample b 
         on...

It's both reasons that it's faster.  To pretend that the shared locks on rows don't take any time is just not true.  It may be small overhead, but it...