>Hi
>
>I'm doing some work on a SQL2005 database.
>
> The site is slowly grinding its way to an upgrade to 2008.
>
>Anyone got a summary of the main benefits of the upgrade and what areas I could look at to get the maximum benefit.
>
>Thanks

Looks like a good overview to me. See the part 1, part 2, part 3 links.

http://stackoverflow.com/questions/198478/advantages-of-ms-sql-server-2008-over-ms-sql-server-2005