SQLServer Temporary tables and database size

Discussion in 'Databases' started by mmrcpv, Sep 13, 2011.

  1. how does it works when ai need create a large temporary table.

    The space limit is the same that i already had or there is another counter to control this situation.

    I did some tests and the "data size" doesn't change when i added a bunch of rows in a temporary table.

  2. Elshadriel

    Elshadriel Winhost Staff

    Could you elaborate on what you mean by the "data size" doesn't change?
  3. I'm executing the command "sp_spaceused", and the information doesn't change when I add a lot of rows in a temporary table.
  4. So...... any new information here ???

    thanks .
  5. Elshadriel

    Elshadriel Winhost Staff

Share This Page