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

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

  • 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

  • RE: Best practice when to use an index

    quote:


    quote:


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


  • 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,...

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


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