Forum Replies Created

Viewing 15 posts - 33,901 through 33,915 (of 49,552 total)

  • RE: Emergency!!!!!!!! Production Databases

    GT-897544 (2/18/2010)

    2) If so go head and bring one database offline and then bring online that should work, if database come online clean, recycle SQL services, should fix all...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 2:20 pm

    #1121351

  • RE: Emergency!!!!!!!! Production Databases

    dennisengel (2/18/2010)

    Status: 65536 Status 2: 1627389952 values for suspect databases.

    As far as I can tell (it's not documented) 65536 in Status is ONLINE.

    1627389952, the only thing I can tell...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 2:19 pm

    #1121349

  • RE: Emergency!!!!!!!! Production Databases

    And the rest of my questions?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 2:05 pm

    #1121336

  • RE: Emergency!!!!!!!! Production Databases

    Dave Ballantyne (2/18/2010)

    If my database were down for that period , we would be losing money hand over fist.

    If my former company's primary DB had been down for 24 hours,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 1:54 pm

    #1121327

  • RE: Emergency!!!!!!!! Production Databases

    dennisengel (2/18/2010)

    When i login into box, i see databases in suspect mode.

    What does SELECT name, status, status2 FROM sysdatabases return for the databases that you can't connect to?

    What is the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 1:42 pm

    #1121313

  • RE: passed 70-432

    Dugi (2/18/2010)

    Sorry I didn't read about exams NDA ... I didn't know about it ...

    You've never taken a cert exam?

    why not to discuss about content of the exam it...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 12:30 pm

    #1121255

  • RE: How to modify 'system stored procedure' SQL 2008?

    As far as I'm aware, you can't modify the system procs and there is no reason, insane or otherwise, to try to do so.

    Write your own procs, put them in...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 12:10 pm

    #1121243

  • RE: passed 70-432

    Dugi (2/18/2010)

    But you should post your opinions about exam, how it was, what questions you had (some interesting or hard to solve), what was the most SQL field part of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 12:10 pm

    #1121242

  • RE: passed 70-432

    ss-457805 (2/18/2010)

    I was surprised that there were only couple of questions on ....

    You're very close to violating the NDA that you accepted when you wrote the exam. Violating that NDA...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 12:07 pm

    #1121239

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (2/18/2010)

    I guess that is where it pays to keep copious records and notes. For some of you guys, that could be quite the lengthy process. Commendable for...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 11:55 am

    #1121223

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/18/2010)

    Actually I already got notice that my stuff was under review. I won't find out if I've done enough to qualify again for six more weeks.

    iirc, I...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 11:36 am

    #1121198

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (2/18/2010)

    As a part of the evaluation, do you submit your own supporting documentation or does MS go and find it? Just curious how much input the nominee has...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 11:32 am

    #1121193

  • RE: UNION a series of TOP statements

    My pleasure.

    I can probably get it even faster if you want, with some appropriate indexes.

    If you're interested, what are the current indexes on the table that you're running this...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 11:23 am

    #1121177

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (2/18/2010)

    See what I know about it? I thought it was an annual deal and nominations were open only for a short period.

    It is an annual deal. If I...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 11:17 am

    #1121168

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (2/18/2010)

    GilaMonster (2/18/2010)

    Steve Jones - Editor (2/18/2010)

    More people trying to be MVP or show off, so there's more participation.

    That was my impression as well. Everyone thinks they're an ex-spurt

    Is the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    February 18, 2010 at 11:12 am

    #1121162

Viewing 15 posts - 33,901 through 33,915 (of 49,552 total)