home.social

#temptable — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #temptable, aggregated by home.social.

  1. Andrea Martin @[email protected] ·

    Ho appena scoperto che, avendo un SQL Server 2019, posso usare la formula
    DROP TABLE IF EXISTS #tempTable

    al posto del controllo:
    IF OBJECT_ID('tempdb..#tempTable') IS NOT NULL

    Tre righe risparmiate.

    #sql

    #temptable #sql
  2. Andrea Martin @[email protected] ·

    Ho appena scoperto che, avendo un SQL Server 2019, posso usare la formula
    DROP TABLE IF EXISTS #tempTable

    al posto del controllo:
    IF OBJECT_ID('tempdb..#tempTable') IS NOT NULL

    Tre righe risparmiate.

    #sql

    #sql #temptable
  3. Andrea Martin @[email protected] ·

    Ho appena scoperto che, avendo un SQL Server 2019, posso usare la formula
    DROP TABLE IF EXISTS #tempTable

    al posto del controllo:
    IF OBJECT_ID('tempdb..#tempTable') IS NOT NULL

    Tre righe risparmiate.

    #sql

    #temptable #sql
  4. PrecisionSQL @[email protected] ·

    How to Use Temporary Tables to Replace Slow Subqueries

    Materialize once. Query fast.

    #mysql #temptable #subquery #performance #howto #query

    youtube.com/watch?v=QdPrJh6RTQY

    #mysql #temptable #subquery #performance #howto #query
  5. PrecisionSQL @[email protected] ·

    How to Use Temporary Tables to Replace Slow Subqueries

    Materialize once. Query fast.

    #mysql #temptable #subquery #performance #howto #query

    youtube.com/watch?v=QdPrJh6RTQY

    #mysql #temptable #subquery #performance #howto #query
  6. Dave Mason @[email protected] ·

    (I was reluctant to make the change because I didn't have a high volume non-production environment to do real world testing.

    Plus, I knew the #TempTable sometimes held as many as a thousand rows...even though the guidance for choosing between a #TempTable and a @TableVariable has changed a bit over the last couple of major releases.)

    /fin

    #temptable
  7. Dave Mason @[email protected] ·

    Somewhat desperate, I decided to replace the #TempTable with a @TableVariable.

    Boom! Problem solved. 😃

    #temptable
  8. Dave Mason @[email protected] ·

    Yet here we were with the same problem once again. This time around, Pam Lahoud's #TempTable guidance was already in place within the stored proc code.

    The server has 128 vCPU and 8 tempdb data files. Maybe I needed to add some more data files?

    Well, I added two more files, but there was no appreciable improvement in performance. Bummer!

    #temptable
  9. Dave Mason @[email protected] ·

    I guess it's too late to be brief, but long story short, when we had this problem before, I modified the stored proc to declare the #TempTable in a single statement (including all constraints, indexes, and compression) along with *not* dropping the #TempTable anywhere within the stored proc code.

    #temptable
  10. Dave Mason @[email protected] ·

    Still, we had this one query near the top of the shit list: a CREATE #TempTable operation.

    We'd had this once in the past, and I eventually realized it was a very high volume stored procedure causing tempdb metadata contention. Pam Lahoud explains the issue very well in this post: techcommunity.microsoft.com/bl

    #temptable