Forum Replies Created

Viewing 15 posts - 22,456 through 22,470 (of 49,552 total)

  • RE: recover data from msdb database

    What exactly do you mean by 'not working fine'?

    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

    November 8, 2011 at 2:17 am

    #1404310

  • RE: Error 9002: The Transaction Log for MSDB database is full.

    Seriously? Do you want this fixed or do you want to mess around for a few more days?

    We need exact errors (and an error that just says 'for more info...

    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

    November 8, 2011 at 2:15 am

    #1404309

  • RE: Error 9002: The Transaction Log for MSDB database is full.

    forsqlserver (11/8/2011)

    Please find the error:

    Windows could not start the sql server on local computer For more information review the sytem event log ,If this is a Non microsoft service ,Contact...

    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

    November 8, 2011 at 2:00 am

    #1404300

  • RE: Error 9002: The Transaction Log for MSDB database is full.

    forsqlserver (11/7/2011)

    This is 2008 R2 standard edition and if any account has not permitted from the logins of sql server to access sql serve then it cannot access and login...

    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

    November 8, 2011 at 1:59 am

    #1404299

  • RE: Filtered index with IS NULL predicate

    SQL Kiwi (11/7/2011)

    Alex Bransky (11/7/2011)

    I'm on SQL 2008 R2 (10.50.1600) and I just created a filtered index with "MyColumn IS NULL" as the filter and my queries appear to be...

    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

    November 8, 2011 at 1:58 am

    #1404298

  • RE: transaction logging throughput

    dmathew011 (11/7/2011)

    Actually this is the question asked in the interview:

    The transaction logging throughput rate — How does one determine the current throughput of written transaction logs?

    Measure it with perfmon....

    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

    November 7, 2011 at 1:01 pm

    #1404152

  • RE: transaction logging throughput

    Archive the throughput? Sorry, don't understand

    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

    November 7, 2011 at 12:27 pm

    #1404139

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/7/2011)

    GilaMonster (11/7/2011)

    Someone with more patience than I have want to finish this? http://www.sqlservercentral.com/Forums/Topic1197753-1550-1.aspx

    So you're un-annoyed now? Or did we just transfer that from the op to us? ...

    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

    November 7, 2011 at 10:29 am

    #1404088

  • RE: Reindex failed primary file group not enough space

    SQLRNNR (11/7/2011)

    GilaMonster (11/7/2011)

    SQLRNNR (11/7/2011)

    We really need to know if that table has a CI. Without it, you can't defrag the other indexes.

    Yes, you can.

    It has always failed 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

    November 7, 2011 at 10:11 am

    #1404077

  • RE: Reindex failed primary file group not enough space

    Ninja's_RGR'us (11/7/2011)

    I don't know those exact internals but it would make sense to copy the index from tempdb to the local db before dropping the old one.

    The index is not...

    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

    November 7, 2011 at 10:09 am

    #1404076

  • RE: Reindex failed primary file group not enough space

    SQLRNNR (11/7/2011)

    We really need to know if that table has a CI. Without it, you can't defrag the other indexes.

    Yes, you can.

    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

    November 7, 2011 at 10:06 am

    #1404072

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/7/2011)

    GilaMonster (11/7/2011)

    Someone with more patience than I have want to finish this? http://www.sqlservercentral.com/Forums/Topic1197753-1550-1.aspx

    I don't have more patience, but I'm less annoyed :-D.

    That works too.

    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

    November 7, 2011 at 9:46 am

    #1404059

  • RE: Are the posted questions getting worse?

    Someone with more patience than I have want to finish this? http://www.sqlservercentral.com/Forums/Topic1197753-1550-1.aspx

    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

    November 7, 2011 at 9:29 am

    #1404044

  • RE: how to convert subquery to a join

    Why do you want to?

    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

    November 7, 2011 at 9:10 am

    #1404021

  • RE: SQL 2005 PERFORMANCE

    ionas (11/7/2011)

    regarding your first issue. Every night we run a maintenance plan where we rebuild all indexes. By the way, since we rebulid is it necessary to Update statistics ?

    Index...

    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

    November 7, 2011 at 9:03 am

    #1404015

Viewing 15 posts - 22,456 through 22,470 (of 49,552 total)