This is just another alternative.  This will count the columns used and pulls out the one that has the most columns used.  More of a straight sql approach.

declare @Op1 int,...

I haven't heard anything about RAID.  If you have 8GB of space on one disk that is partitioned into 3 drive letters, moving files wont do any bit of good. ...

Please post the code.

A couple of areas to check.  If you "SET" a variable, make sure that the select statement doesn't return more than one row.  In your select statement,...

Even if the "Database Recovery Model" is set to "SIMPLE" you can still grow the transaction log file until there is no more disk.  If a lot of data is...

What I have done was created a simple stored procedure that accepts the parameter of @tablename.

CREATE PROCEDURE sps_TruncateTable (@Table VARCHAR(100))

AS

BEGIN

EXEC ('TRUNCATE TABLE ' + @Table)

END

Then add the stored...

I would recommend doing a Index Rebuild and a statistics FULLSCAN of indexes. Without seeing the execution plan, I would be interested in the "Estimated Row Count." Is...

I am not sure which one, but I think DBCC INDEXDEFRAG or DBCC DBREINDEX use TempDB to reorganize the data pages. If you rebuild/defrag your indexes in the production...