SQL Server 2008 changes the way that CONVERT/CAST works

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

Share

2 Responses

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trust DCAC with your data

Your data systems may be treading water today, but are they prepared for the next phase of your business growth?