Post reply

Size of nvarchar(max)??

  • June 22, 2015 at 11:45 pm

    #319385

    Comments posted to this topic are about the item Size of nvarchar(max)??

    Thanks,
    Shiva N
    Database Consultant

  • June 23, 2015 at 2:09 am

    #1807262

    It was a 50-50 guess as to whether "size" was supposed to mean storage size or number of characters. I guessed wrong 🙁

    Surprise that (at the time of writing) the number of people making the same wrong guess is outnumbered by those going for 2MB!

  • June 23, 2015 at 3:10 am

    This was removed by the editor as SPAM

  • June 23, 2015 at 4:08 am

    #1807285

    Toreador (6/23/2015)

    It was a 50-50 guess as to whether "size" was supposed to mean storage size or number of characters. I guessed wrong 🙁

    Surprise that (at the time of writing) the number of people making the same wrong guess is outnumbered by those going for 2MB!

    I didn't think there was a 50-50 guess, because "size" and "length" are quite different concepts. It's quite normal to say that an nchar string has twice teh size of a char string of the same length. But I can see that it's an easy trap to fall into.

    I'm not just surprised amazed that more than 1 person in 6 has answered 2MB, I'm amazed.

    Tom

  • June 23, 2015 at 5:57 am

    #1807309

    TomThomson (6/23/2015)

    I'm not just surprised amazed that more than 1 person in 6 has answered 2MB, I'm amazed.

    I have to agree that the results to this point are a bit surprising.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • June 23, 2015 at 6:09 am

    #1807315

    Toreador (6/23/2015)

    It was a 50-50 guess as to whether "size" was supposed to mean storage size or number of characters. I guessed wrong 🙁

    Surprise that (at the time of writing) the number of people making the same wrong guess is outnumbered by those going for 2MB!

    I also guessed it wrong, but at least learned somthing new today, so thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • June 23, 2015 at 8:36 am

    #1807397

    I think this was easy, easy. Thanks, Shiva!

  • June 23, 2015 at 11:58 pm

    #1807625

    nice, easy and informative. Thanks for sharing

  • June 24, 2015 at 2:41 am

    #1807661

    Easy one, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 24, 2015 at 11:50 pm

    #1807934

    That's quite a lot. I didn't know it.

  • June 25, 2015 at 7:05 am

    #1808038

    Thanks for the question.

  • June 30, 2015 at 3:23 am

    #1809017

    Very Easy 🙂

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply