Home Forums Microsoft Access Microsoft Access Slow performance after Migration from Access to SQL back-end RE: Slow performance after Migration from Access to SQL back-end

  • Jeff Moden (6/26/2011)


    As a side bar, you might want to avoid using ORDER BY X where X is an integer.. . . and, second, it's been deprecated. 😉

    Jeff,

    Can you cite a reference for this? According to the 2008 R2 docs, you can still use it unless using a ranking function. TIA