Post reply

Update State

  • April 12, 2012 at 10:02 am

    #272133

    Hello Guys,

    What is update state in sql servers ?

    Is it state of table when any update query fire?

  • April 12, 2012 at 1:05 pm

    #1472891

    Were you asked this question or are you observing this somewhere. If you have observed it, can you please be more specific as to how and where?

    Jared
    CE - Microsoft

  • April 12, 2012 at 11:05 pm

    #1473024

    Haven't heard about Update State before. Are you asking about "Update Statistics"???

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • April 13, 2012 at 10:57 am

    #1473353

    Yes, I am asking question. I have not observe it before but i attended an interview and inverviewer asked me this question " What is update state?"

    So i want to know what is that and where can I found that. According to me the state of update processing query is the update state. or any record which are in state of updation.

    Not sure as I am new to sql environment and clearing my basic fundamentals.

    Any suggestion and assistance to understand are appreciated.

    Thanks a lot guys.!

  • April 13, 2012 at 11:58 am

    #1473396

    jitendra.padhiyar (4/13/2012)

    Yes, I am asking question. I have not observe it before but i attended an interview and inverviewer asked me this question " What is update state?"

    So i want to know what is that and where can I found that. According to me the state of update processing query is the update state. or any record which are in state of updation.

    Not sure as I am new to sql environment and clearing my basic fundamentals.

    Any suggestion and assistance to understand are appreciated.

    Thanks a lot guys.!

    they might have been talking about this??

    http://msdn.microsoft.com/en-us/library/microsoft.updateservices.administration.updatestate(v=vs.85).aspx

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • April 13, 2012 at 10:20 pm

    #1473603

    capn.hector (4/13/2012)

    jitendra.padhiyar (4/13/2012)

    Yes, I am asking question. I have not observe it before but i attended an interview and inverviewer asked me this question " What is update state?"

    So i want to know what is that and where can I found that. According to me the state of update processing query is the update state. or any record which are in state of updation.

    Not sure as I am new to sql environment and clearing my basic fundamentals.

    Any suggestion and assistance to understand are appreciated.

    Thanks a lot guys.!

    they might have been talking about this??

    http://msdn.microsoft.com/en-us/library/microsoft.updateservices.administration.updatestate(v=vs.85).aspx

    Yup!!...that's it.

    As always Capn. Hector saves the day...:-D

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

Viewing 6 posts - 1 through 5 (of 5 total)

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