have you checked your free disk space size lately?

master..xp_fixeddrives

only nonclustered indexes can be moved to a separate filegroup.  your clustered index stays with the table.

If you're looking to get rid of that other file, you will have to dbcc...

and if xp_cmdshell is restricted because of security constraints, you always have the sp_OAxxxxxx procedures to help you out......

you need to account for your fill factor too.... asuming you're not taking the default.

where RowID = convert(int,(Rand()*(3-1)+1))

Yours before was returning a floating point value 2.38898 (or some other random float)

That's why you're not getting anything back.

You need to understand datatypes and how they...

In profiler add just the following event:

Performance:ExecutionPlan

you will see something like the following in textdata

Execution Tree

--------------

Compute Scalar(DEFINE[LabLink_01212006].[TextData]=[LabLink_01212006].[TextData]))

  |--Filter(WHERElike([LabLink_01212006].[TextData],...

Are you sure 3.6GB is allocated to SQLServer?  Or does the box have 3.6GB but SQLServer is only taking up to 2GB.  Simply looking at "taskmgr" to see is not...

select spid from master..sysprocesses where program_name = 'MS SQLEM'

kill those spids.

I'll warn you before though,  if you get spids 50,51,52 from the above query, there is no guarantee that 3 seconds...

sp_msforeachdb '?..sp_stored_procedures'

sp_msforeachdb is an undocumented procedure

Might want to consider placing your indexes into a separate file on a separate physical disk.

Thanks all.  I think the shrinkfile, empty file method is the way I want to go.  I'll have to set up a test scenario and try that out.  BOL says...

change this to : (add switches /b/s)

 EXEC master..xp_cmdshell 'dir \\SERVERNAME\DIRECTORY(Shared If Required)\*.PDF /b/s'

change *.* to *.PDF for a bit of a performance boost

and you can get rid of the...

FROM BOL: copy and pasted

STOPAT = date_time | @date_time_var

Specifies that the database be restored to the state it was in as of the specified date and time. If a...