Chris Lee from the Data Works team has a great post on using MARS in SQL Server 2005, simple but effective.