MSDN Magazine PDF download

At the link below you can download MSDN Magazine in PDF format. Its pretty up-to-date with April 2011 issue 🙂


SQL Server 2000 system processes

The following SQL command can be used to list all system processes that waits on processing time on the SQL server.

select count(spid), cmd, program_name
from master.dbo.sysprocesses
where spid >= 50 and spid <> @@SPID
group by cmd, program_name