First off, for clustering support and expansion of volumes, all disks should be basic. That said, you'll need to create a cluster resource for the new volume, take the SQL...

I've updated statistics and I'm now correctly reporting the rowcounts of sysindexes, sysobjects, and syscolumns.

Unfortunately, today is relatively light volume, so I wasn't experiencing any issues and can't determine...

Thanks John, that's definately something to look into. We're currently using local temp tables, as they may be populated with different information depending on the options the SP was executed...

I don't usually drop and rebuild system indexes. The page in question belongs to TempDB.dbo.sysindexes. My uptime is 35 days, so that would be the last time the index was...

I've looked over this KB article and splitting the TempDB into multiple files could definately help performance. My only concern is that I haven't been seeing 2:1:1 or 2:1:3 as...

I'm not in front of the system, so I can't give you the actual text of the last command. It's a reindexing job as setup by a maintenance plan. No...

It can be rebooted, but users need to be warned in advance. So yes, 365 x 24 is the goal. I'm less concerned about why this is happening, more concerned...

Dual 1 GHz Processors, 1 GB RAM, 2 GB Database. Job is scheduled through SQLMaint, it reindexes 5 2GB DB's in the same job.