Home Forums SQL Server 2008 SQL Server 2008 - General is there any change in query execution time , when we replace NTEXT with nVARCHAR ? RE: is there any change in query execution time , when we replace NTEXT with nVARCHAR ?

  • November 1, 2012 at 6:00 am

    #1554965

    May be it will boost your performance,

    you can create index on varchar which is not possible on ntext.

    but still it depend upon the length of you data.

    -----------------------------------------------------------------------------
    संकेत कोकणे