Normally when running a query against a table and using a CAST or CONVERT function against a datetime field any index is made useless. In SQL Server 2008 this problem is fixed. Microsoft has come up with a way for SELECT statements which use CAST or CONVERT against a column of the datetime datatype to continue to use the index. Now keep in mind that this only works for the datetime datatypes and not other data types.
I believe that this feature showed up in CTP 5 (November).
I was expecting to see your name on the presenter’s list for the SQL LEARNING DAY in the FireStarter Event on May in Irvine MTC. I didn’t see your name. Check it out http://www.firestarterevents.com/Presenters/tabid/57/Default.aspx
I hope you can expound more on the new feautures of SQL 2008 with real world examples…
This is the first that I’ve heard about this event. I’ll see what I can do about getting on the schedule to speak at it. I’ll see how booked the schedule is. Thanks for letting me know about it.