Here is sample code .

DECLARE @cmd nvarchar(500),@folderName varchar(100)

Declare @firstday int

Set @firstday =DATEPART(day, GETDATE())

If...

This query will give the last windows restart time.

SELECT

DATEADD(s,((-1)*([ms_ticks]/1000)),GETDATE()) AS last_restart

FROM sys.[dm_os_sys_info];

Here is a query to find.

Select STATS_DATE(object_id, stats_id) LastUpdate , * From sys.stats

Do you have proper indexes are there on table if yes then Analyze all your indexes to identify non-performing indexes and missing indexes that can improve performance. also...

Have you killed the session 158 ? after that only you can fire kill 158 with statusonly to get the roll back status.

Try query hint with nolock on your search query. so that no shared locks are issued against the table that would prohibit other transactions from modifying the data in...

EXEC xp_cmdshell 'copy c:\sqldumps\pubs.dmp \\server2\backups\sqldumps',

NO_OUTPUT

http://msdn.microsoft.com/en-us/library/aa260689(v=sql.80).aspx

you can try it with xp_cmdshell

good query..

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/da2680f2-7a22-46f9-9556-2218897f88fa/

Article for Concurrency enhancements for the tempdb database

- http://support.microsoft.com/kb/328551

http://www.sql-server-pro.com/i-o-requests-taking-longer-than-15-seconds-to-complete.html

I did SP4 installation on services stopped. it went fine without any issue.

Here is updated query ..

select a.FILEID,

[FILE_SIZE_MB] =

convert(decimal(12,2),round(a.size/128.000,2)),

...

Use DB

Select * from sys.sysfiles