home.social

#temptable — Public Fediverse posts

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

fetched live
  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. 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
  3. 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