John Paul Cook has a great post on how to get started with spatial data in SQL Server 2008. I especially liked that he included a picture of the spatial results tab. Definitely of use if you are looking for a reason to switch to SQL 2008.