Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2007
    Posts
    97

    Unanswered: Estimate Size Of A Temporary Table

    Hello,

    how can I estimate the size (KB) of a temptable?

    Thank You

    silas

  2. #2
    Join Date
    Mar 2007
    Posts
    97
    Please, can you give me some hints how to solve this issue?

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by silas
    Please, can you give me some hints how to solve this issue?
    It's as big a you fill it up...what's the question?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Mar 2007
    Posts
    97
    Quote Originally Posted by Brett Kaiser
    It's as big a you fill it up...what's the question?
    You misunderstood me. My question was "how to get the size", not "what's the size".

    There is sp_spaceused, but this function doesn't work with temptables. The thing is, the user can create as many temptables as he wants. But this uses up the memory. So I need a way, to estimate the size of each temptable and the remaining memory.
    Last edited by silas; 09-06-07 at 06:23.

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Why is the size important?

    Size depends on amount of data and the datatype of the data.
    George
    Home | Blog

  7. #7
    Join Date
    Mar 2007
    Posts
    97
    Quote Originally Posted by georgev
    Why is the size important?
    See above...

  8. #8
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Last edited by silas at 10:23...
    You cannae fool me laddie

    This link will help you find your answer...
    George
    Home | Blog

Posting Permissions

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