22,209
社区成员
发帖
与我相关
我的任务
分享
create clustered index SerId_Index
on dbo.temp_Cost_Tape_Cost_Raw_Data(Service_Order_ID)
with (drop_existing=on)
SELECT spid,blocked,waittime,waittype,waitresource,p.dbid,cpu,physical_io,memusage,open_tran
,status,login_time,last_batch,hostname,program_name,hostprocess,loginame,cmd,text
FROM master.dbo.sysprocesses p CROSS APPLY sys.dm_exec_sql_text(p.sql_handle) s
WHERE blocked > 0 OR spid IN(SELECT blocked FROM master.dbo.sysprocesses WHERE blocked > 0)
go