We were making # tables. We have considered making permanent tables for each process (e.g. TTemp_MaintainActuals1, TTemp_MaintainActuals2, TTemp_MaintainActuals3, TTemp_MaintainActuals4 ... TTemp_MaintainActuals32767) but that would require quite...

Excellent question! And one we have considered. We found that creating temporary tables for each process was significantly slower than using permanent ones.

The "it" was the suggested solution:
SELECT TOP 5 PERCENT *
FROM...

Interesting, because I had thought that any function that took no parameters or a hard coded value parameter would only be evaluated once and would return the same...

You quite rightly say

I guess I just don't understand the use case that requires this. Foreign Keys exist to enforce a relationship, which you are effectively over-riding and creating a...

Thanks everybody. We're getting some promising-looking results from a very similar idea - that of making #InsertedDeleted from a full join of #Inserted and #Deleted and then using it in...

Thanks very much for that. Obvious (in retrospect!)

Thanks for your reply.

Probably all manner of things! So what you're saying is that all...