Forum Replies Created

Viewing 15 posts - 4,696 through 4,710 (of 8,753 total)

  • RE: Are the posted questions getting worse?

    Gail, thank you for the correctio back there, makes me feel kind of sheepish

    😎

  • RE: Database in Recovery

    GilaMonster (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Chris.Hubbard4U (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Chris.Hubbard4U (8/14/2015)


    I have a database In Recovery.

    Where do I check the completion status of the recovery?

    Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'

    😎

    I queried...

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/14/2015)


    Heh... since it's for XML...

    Trying to put my finger on this, just cannot find which kind of XML phobia is plaguing you Jeff:Whistling:, so far I've checked these

    😎

    Ablutophobia...

  • RE: Unable to link data from data pulled from XML

    drew.allen (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Further, I was only stating that with a properly written XQuery, using the text() function is much quicker, I was not commenting or comparing to yours or...

  • RE: SELECT @@ServerName returns NULL

    Chris.Hubbard4U (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Chris.Hubbard4U (8/14/2015)


    Where I execute the command SELECT @@ServerName it returns NULL?

    This just started today.

    What could cause that?

    What does SELECT SERVERPROPERTY ( 'InstanceName' ) return?

    😎

    NULL:unsure:

    Are you connected to...

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Ed Wagner (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Alvin Ramard (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    SQLRNNR (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Sometimes one wonders what drives the responds when one points out that the posted solutions...

  • RE: Seeking guidance regarding a tSQL Script

    tjs8984 (8/14/2015)


    Hello,

    It is implied that if there are two occurrences of the same [Name] element then one will have the AnnualizingFactor of 2080.

    Correct. When two occurrences with...

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Alvin Ramard (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    SQLRNNR (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.

    😎

    Maybe he...

  • RE: SELECT @@ServerName returns NULL

    Chris.Hubbard4U (8/14/2015)


    Where I execute the command SELECT @@ServerName it returns NULL?

    This just started today.

    What could cause that?

    What does SELECT SERVERPROPERTY ( 'InstanceName' ) return?

    😎

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    SQLRNNR (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.

    😎

    Maybe he has coded it differently...

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.

    😎

    Maybe he has coded it differently than you guys? ...

  • RE: Seeking guidance regarding a tSQL Script

    It is implied that if there are two occurrences of the same [Name] element then one will have the AnnualizingFactor of 2080. It is also implied that under no other...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/14/2015)


    Jack Corbett (8/14/2015)


    Eirikur Eiriksson (8/14/2015)


    Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.

    😎

    But you didn't do it...

  • RE: How to use 'or' with a substring

    owens.rusty (8/14/2015)


    I have a table where we have created a column that has which contains a column which is a primary key tying back to another table. The problem...

  • RE: Database in Recovery

    Chris.Hubbard4U (8/14/2015)


    It finally recovered.:-)

    Good stuff and have a great weekend:-)

    😎

Viewing 15 posts - 4,696 through 4,710 (of 8,753 total)