Agreed, contradicted myself. If one do a proper db design it should not be an issue, secondly index can only help optimizer!

-p = precision_level Specifies the maximum level of precision to be supported by decimal and numeric data types. By default, SQL Server has a maximum precision of 28. The acceptable...

What is the record size? Will all data fit on one SQL page?

What is the Model database setting?

Sorry, obviously autogrow for TempDB must be switched on.

Seems like, for the current situation, there is not enough disk space as the error indicated. Reboot should clean out / recreate TempDB. Assign another filegroup to TEMPDB on a...

Try, did read the complete articles. Cannot find my old example.

http://www3.sympatico.ca/n.rieck/docs/mqseries_client_on_openvms.html

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/30/pid/332/qid/495632

Like the tack hammer comparison, but if you are working on the crown jewels of the company, bla,bla.

As an after thought switch IIS logging off, saves cpu cycles.

If multi disks move tempdb,data and log onto their own different disks.

I thought it may have a bearing on whether the table has an index or not, how SQL handle tables without PKs.

First made second column an primary index. Problem persist.

Secondly...

Try, not completed :

Select Name As TableName,

Case When DelTrig<>0 Then IsNull(Objectproperty(DelTrig,'ExecIsTriggerDisabled'),'') Else '' End as DeleteTriggerDisabled,

Case...

The " I am also losing records from this DB," is a real concern. Did you run DBCC CheckDB, check the errorlog?

Try article at

http://www.sql-server-performance.com/log_explorer_spotlight.asp

Agrees with previous poster, limit the query to a smaller record set for starters.

Remember to defrag, update stats, etc.

See BOL 2000: SET DATEFIRST