I use the following easy-to-memorize SQL to get column lists:

select ', ' + name from syscolumns where id = object_id( 'MyTable' ) order by colorder

or

select ', ' + column_name from...

There are a few things to consider...

tempdb could be growing to that size because it needs to.  Possibly, tables are being created, lots of data are inserted, and the tables are...

I have several databases on EMC SANs. My only emphasis is to be sure to physically design your database files as you would on any other RAID or set...