This is something I haven't noticed before but I think it's mighty cool! When you choose to Include the Actual Execution Plan in SSMS 2008 it suggest any missing indexes it thinks that are needed. Plus it also calculates the performance benefit from adding them. I'm guessing the number (green 84.7361 in the picture) is in percent... So it's like a Database Tuning Advisor "Lite" :)) And best of all this also works when you're connected to a SQL Server 2000 or 2005. This is what it looks like: I'm starting to like this new SSMS...
I've written a second article here on SQL Team on how to schedule jobs in SQL Server 2005 Express.
Intro
In my previous article we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based on Service Broker worthy of the SQL Server Agent itself including run once, daily, weekly, monthly absolute and relative scheduling:
Scheduling Jobs in SQL Server Express - Part 2
And part 1 of this series:
Scheduling...