Forum Replies Created

Viewing 6 posts - 16 through 22 (of 22 total)

  • RE: QOD 1/8/03 (or is it 8/1/03?)

    My preferred alternative (and a variation on choice 4) is to do:

    WHERE CAST(CONVERT(char(8), DateVal, 112) AS datetime) = '2003-08-01'

    Mainly because I prefer the intermediate character format to casting to a...

    August 1, 2003 at 3:59 am

    #468156

  • RE: Best practice when to use an index

    quote:

    I read somewhere that although you can specify 8, 16 and 32 bit integers windows converts these all into 32 bit integers...

    July 10, 2003 at 4:35 am

    #464781

  • RE: QOD june 27 select * from

    So, the QOD was a test to understand if we knew the workaround for a bug that has been fixed since MDAC 2.1? Hmmm....

    --

    Si Chan

    Database Administrator

    July 1, 2003 at 3:21 am

    #463734

  • RE: Best practice when to use an index

    quote:

    quote:

    In my book, indexes are for data integrity or performance.

    June 25, 2003 at 7:24 am

    #463008

  • RE: Best practice when to use an index

    quote:

    So, why use an index anyway, that's what I was originally asking.

    In my book,...

    June 25, 2003 at 7:01 am

    #463001

  • RE: Best practice when to use an index

    quote:

    that's what the tables are. 2, maybe 3 columns.

    the data inserted hardly never changes. From year to year I guess.

    June 25, 2003 at 5:58 am

    #462987

    • Viewing 6 posts - 16 through 22 (of 22 total)