Run performance monitor to see whether there are too much workloads on the I/O disks your database reside on. I highly suspect that.

Increase the "cost threshold for parallelism" from 5...

Depend on how your database be backed up. If database was backed up by using T-SQL backup statement, you have to perform the restoration. If the database files (MDF and...

What client tools are you referring to? If you have SQL Server license, you can use SQL Server tools like QA and EM for your MSDE.

Run select * from sysprocesses where waittime > 0 order by waittime desc to see what SQL Server are waitting for.

How many CPUs do you have? Do you enable Parallel...

I am wondering there are some large queries running. Check all your schedule jobs and run Profiler to see which queries consume CPUs time.

Please post "select * from sysprocesses where...

Distribution statistics may also be maintained for unindexed columns. These can be defined manually using the CREATE STATISTICS statement or created automatically by the query optimizer. Statistics on unindexed columns...

http://support.microsoft.com/default.aspx?scid=kb;en-us;297104&Product=sql2k

Could there be mulitiple backup files you have to restore together?

Run DBCC CHECKDB to your database.

I tested similar queries of yours with 500000 records and do not see any differences.

SELECT            TOP 500000 *

FROM  webproxylog

WHERE logdate BETWEEN CONVERT(VarChar(10),Getdate()-100,126) AND CONVERT(VarChar(10),Getdate(),126)

SELECT            TOP 500000 *

FROM  webproxylog

WHERE  (logdate =...

You can backup the currently active transaction log even if the database file is damaged, provided that the transaction log file is still accessible.

Backup Log <database_name> to Disk = <device_name>...

Don't do that.

Grant the new windows local group with EM or sp_addlogin.

Post that statement which give you this error message here.

Ok. Paste your script into QA, Run it, get error, click the error and it will tell you which statement is wrong. Post that statement here.

"Server: Msg 15009, Level 16, State 1, Procedure sp_help, Line 71 The object 'sp_schedule_status_reset' does not exist in database 'master'"

Above error message indicates that you have error at line 71...

How do you rebuild the indexes? Run create index command or dbcc dbreindex? It is true the log space usage will be minimized by setting recovery model to "bulk-logged" if...