SQL Server 2008 changes the way that CONVERT/CAST works

Published On: 2008-04-07By:

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

Contact the Author | Contact DCAC

2 responses to “SQL Server 2008 changes the way that CONVERT/CAST works”

  1. MarlonR says:

    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

  2. Mrdenny says:

    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

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP
Share via