title: Query temporary table and Transaction log growing?
body: <p>I am working on a project to just simple query (simple select). For that, there is many logic behind and I created  many temporary table inside the query (#).</p>
  
  <p>Our database was facing a problem since last week, the size of the transaction file was big and just growing and the DBA shrinked the file but when I run my query today, I could not run my query again. </p>
  
  <p>I checked the size of the transaction log and it's starting to grow again even without I do anything. I want to know if it is because I have many temporary table (#) in my query? or our DBA should maintain that? Thank you </p>