title: TempDB Log File Growth Using Global Temp Tables
body: <p>This is really a two prong question.</p>
  
  <p>One, I'm experiencing a phenomenon where SQL server consumes a lot of tempDB <strong>log</strong> file space when using a global temp table while using a local temp table will consume data file space?</p>
  
  <p>Is this normal? I can't find anywhere on the web where it talks about consuming log file space in such a way when using global temp tables vs. local temp tables.</p>
  
  <p>Two, if this is expected behavior, is there any way to tell it not to do this :). I have plenty of data space (6 GB), but my log space is restricted (750 MB with limited growth). As usual, the tempDB is setup with Simple Recovery so running into the log file space limit has never been a problem before ... but I've never used global temp tables like I'm using them before either.</p>
  
  <p>Thanks!! Joel</p>