according to sp_spaceused, there is unused space allocated for tables.

http://msdn.microsoft.com/en-us/library/ms188776.aspx

I can make unused space by adding rows and deleting them. just hoping there is a more elegant...

thanks, that is the fix

make sure statistics are up to date.

you can probably pick one up on ebay.

good luck

this error can come from a couple issues.

the fix for me was to change the service account with enterprise manager which will grant needed local policy and confirm the exact...

I too had this issue, seems one should not change the full text service through the services gui or a wmi script.  instead Use SQL Server Configuration Manager to reapply...

be aware, linked servers are slow if you have a lot of data returned by a linked query...

thanks for all that useless information - here are the answers I was looking for:

In Spring, jobs scheduled during the spring ahead hour from 2 - 2:59:59am will launch at 3am (I...

try reindexing the tables.

if you deleted data the indexes are probably very fragmented.

does the error message come from an attempt to connect via a linked server?  the server principal name (SPN) may not be correctly identified. 

what is fill factor on the db on the cluster server?

if fill factor is too high, inserts may take a long time

you state that log file increased, I assume it is on autogrow.

how much is free space? you can probably shrink it.

some optimization jobs (defragging indexes) take up log space.

I would make sure there are indexes on every column used in the where clause.

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

is this any help

http://www.codeproject.com/system/sid.asp