SQL Server Performance

_bstr_t data type length problem in ADO

Discussion in 'T-SQL Performance Tuning for Developers' started by mtmingus, Oct 8, 2003.

  1. mtmingus New Member

    Did anyone have problem with this type of data type?
    It is reported that when the system is heavily loaded
    and sqlserver is running like crazy, _bstr_t (returned
    from ADO RecordSet) max it to 500 characters.
  2. Luis Martin Moderator

    Kindly, zackhu, only write same post in one place.



    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  3. mtmingus New Member

    Sorry that It was definitely my fault by
    placing this on the dba forum. It should be
    a developer issue. I was waiting for someone
    to move it over to the dev forum but a few
    hrs after there was no action, so I took the
    liberty and placed this here.

    quote:Originally posted by Luismartin_ar@yahoo.com

    Kindly, zackhu, only write same post in one place.



    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell

Share This Page