SQL Server with Mr. Denny

Apr 7 2008   11:00AM GMT

SQL Server 2008 changes the way that CONVERT/CAST works

Denny Cherry Denny Cherry Profile: Denny Cherry


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).


2  Comments on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • MarlonR
    Denny, 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... -Marlon Ribunal
    50 pointsBadges:
  • Denny Cherry
    Marlon, 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. Denny
    69,055 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: