Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2015

    Unanswered: Difference between Tempdb.dbo.tblname vs #tempdbObj

    how will you differentiate directly accessing Tempdb database e.g tempdb.dbo.tblname vs using hash temporary objects #tempdbObj, with regards to its functionality and performance

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    You don't differentiate them.

    Do you have specific questions or use cases?

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts