Post reply

Constraints for temp tables

  • February 1, 2022 at 9:53 am

    #3979492

    I don't see an issue in using randomly generated PK names for temp tables

  • February 1, 2022 at 10:08 am

    #3979504

    There is no issue with letting SQL generate the PK name for the temp table.

    That said, there is no guarantee that your script will run any faster when running 2 or more concurrent versions of the same script.  In fact, you may even find that it runs slower as the scripts may be accessing the same data pages, causing blocking.

    How to post data/code on a forum to get the best help.

  • February 1, 2022 at 10:42 am

    #3979509

    Hi Guys

    Thanks for the quick replies!

    I did have some issues with page locks when i started trying to set it up but I've set each job to run on a separate date range which seems to have resolved that. And i did some index work that has helped to make it run faster. Still gong to take a while though just because it has been left to accumulate such a huge amount of data over the course of about ten years!

    Thanks again for the help. Very much appreciated.

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply