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 🙂

http://msdn.microsoft.com/nb-no/magazine/ee412244(en-us).aspx

Advertisements

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