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

Denny

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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:
    report
  • 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
    66,130 pointsBadges:
    report

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: