After shrinks, I've had good luck very often with just a REORGANIZE overall ~80-85%, rebuild required ~15-20% of the time.  Start with the smaller tables first, moving up in size...

For storing of SSN, you might consider adding a check digit to the value, so that it does become 10 digits (or 11 or whatever).  That way they are trying...

You could use a SEQUENCE, or if that is not available, insert the SSN into table with an identity and use the identity value as a link back to the...

Select Code, new_string
FROM #Temp
CROSS APPLY (
    SELECT STUFF(Code, 1, 1, '') AS base_string
) AS ca1
CROSS APPLY (
    SELECT LEFT(base_string,...

SELECT in the CROSS APPLY is more flexible, in that it makes it easier to assign multiple alias names and allows for table access to be part of assigning an...

Somewhat confusing, but I think this may return the rows you want:

SELECT T.*, Z.*
FROM
#TEMP1 T
INNER JOIN
[TSI].[ZATS_BROKER_FEED] Z
ON T.Part_Num...

Non-clustered index(es) are almost always a waste of resources on a staging table.  

A clustered index is much more likely to be useful, although it's obviously not guaranteed to...

You don't really need a cursor for what you're described.

DECLARE @job_name_pattern nvarchar(128)
DECLARE @sql nvarchar(max)

SET @job_name_pattern = 'MyJobEvery%'

SELECT @sql = CAST((