There's a lot in SQL2005 I haven't taken advantage of, and I'm probably not alone, but here's a new SQL2005 feature that I use all the time: Object Explorer Filtering. What it does is restrict the display of objects in the left-hand SQL2005 explorer to those which contain certain name, schema or creation date properties. Right-click on an explorer folder to view the filter setting dialog.
This is particularly useful with Community Server since there are a ton of both tables and stored procedures that you normally must wade through to find your custom objects. With filtering I only view my application data objects.
