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


Contact the Author | Contact DCAC

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

  1. MarlonR says:


    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:

    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.



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   Denny Cherry & Associates Consulting LLC BBB Business Review    Microsoft MVP    Microsoft Certified Master VMWare vExpert
INC 5000 Award for 2020    American Business Awards People's Choice    American Business Awards Gold Award    American Business Awards Silver Award    FT Americas’ Fastest Growing Companies 2020   
Best Full-Service Cloud Technology Consulting Company       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers
Share via
Copy link