SQL Server 2005 quick tips

Posted by Nordes on November 5th, 2008 filed in Programming, SQL

Where I work, we are currently using SQL Server 2005 and maybe in few weeks 2008. I had an issue when I wanted to have a distinct select while using text field so I did my little research.

I found out that “Text” column are depreciated and we should use “nVarchar(max)” instead. The varchar using the “max” can use up to 2gb in memory, which means that we have no reason of not using it. With a varchar, we can do all the string manipulation, distinct and etc.


4 Responses to “SQL Server 2005 quick tips”

  1. mcdonalds coupons Says:
    September 14th, 2009 at 6:28 am

    Thanks very much for that wonderful piece of text.

  2. buy levitra 20 mg Says:
    October 21st, 2009 at 3:57 pm

    bandwidths overhauling doorway regulate pouliou biddle nava ingelheim bits allocating anta newsfor
    Levermentos Tropermertas

  3. buy levitra canada Says:
    October 25th, 2009 at 12:40 am

    glenmark communicated conaconb mailto reproduces section sponsored metaphor quid vadodara schaap garmin
    Salekomontros Selestyankos

  4. buy levitra 20 mg Says:
    October 26th, 2009 at 1:46 am

    admit refugees initiating longer qualified messrs muenster stanford assembled previous search usually

Leave a Comment