I prefer the format "<table_name>__DF_<column_name>".  I think it's more useful to prefix constraints with the table name rather than "DF_".  Just because MS did it that way doesn't mean it's...

The second-highest score should always give you the desired value:

SELECT t.ID, t.Score1, t.Score2, t.Score3, ca1.FinalScore
FROM #tmp t
CROSS APPLY (
    SELECT TOP...

If the tables are not too large, you could even consider using CASCADE only when deliberately making changes, i.e., drop the FK constraints, recreate them as CASCADE, change the name(s),...

Just UNION (not UNION ALL) the two tables:


SELECT *
FROM #temp1
UNION
SELECT *
FROM #temp2
ORDER BY <column_name>

You can use your initial DELETE, perhaps looping it as well:

DELETE TOP (50000) FROM WHERE DATE BETWEEN X AND Y;

You'd be better off clustering...

Try this:

SELECT T.InvoiceNumber, T.EntryCode AS InvoiceEntryCode, T.StoreNumber AS InvoiceStoreNumber, T.RptLevel AS InvoiceRptType,
OA1.*
FROM #tmpTransactions T
   OUTER APPLY (
    SELECT TOP...

You should look into using sql_variant data type, it could help you do this.  You'd have to use the desired data type, or cast to an explicit type, when loading...

For now, off the top of my head, I don't see any way to avoid a cursor. so that you can dynamically evaluate each expression using sp_executesql.  But other than...

And don't forget about extended properties.  Those would all be lost too if you DROP/CREATE.  As would of course any original "create_date".

Change your table to never store the space in the post code column (you can use a trigger to do this, at least until you change the app; you can...

If the format is always xxx###, then:
SELECT MAX(RIGHT(column, 3))

Here's another alternative.  Btw, I corrected two holiday descriptions, for Jan and Feb.  It's not "President's Day", it's "[George] Washington's Birthday"; I wish the media would stop repeating the wrong...

I think something along these lines:

SELECT user,
  CASE WHEN confirmed_count = user_count THEN 'Confirmed'
   WHEN not_confirmed_count > 0 THEN 'Not Confirmed'
   WHEN confirmed_with_caveat_count >...