Forum Replies Created

Viewing 15 posts - 14,296 through 14,310 (of 49,552 total)

  • RE: logical consistency-based I/O error

    Chris Burton-434978 (2/13/2013)

    We had similar corruption to this in msdb last week with Parent node for page (X:XXX) was not encountered errors

    I took a backup which included the corruption and...

    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 13, 2013 at 9:22 am

    #1587539

  • RE: Emergency state

    SQL will not go into emergency mode by itself. Someone has to have set it to emergency.

    What exactly happened, why was the DB set into emergency mode and what is...

    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 13, 2013 at 7:01 am

    #1587437

  • RE: How come my log file is still now able to grow?

    You've probably got a % growth like 10% (very bad default) and an IO subsystem under strain so that the log can't grow and zero-out the requested size in 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 13, 2013 at 1:02 am

    #1587306

  • RE: Is there any way to find out if an instance/DB is in cluster or not ?

    SELECT SERVERPROPERTY('IsClustered')

    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 13, 2013 at 1:00 am

    #1587305

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (2/13/2013)

    I've copy pasted their question as-is into Google, and the first result had their answer.

    Same, and when I do, I'll post the link to the search...

    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 13, 2013 at 12:59 am

    #1587304

  • RE: Are the posted questions getting worse?

    Personally I find LMGTFY to be incredibly condescending, I'd feel quite insulted if someone gave me that kind of reply. I'll do the search for people if I don't think...

    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 13, 2013 at 12:22 am

    #1587299

  • RE: How to estimate how much time a script will run?

    Lowell (2/12/2013)

    at least viewing the estimated execution plan would give you a ballpark number;

    Where 'ballpark' is the size of half a continent. 🙂

    Run the script in a test environment with...

    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 12, 2013 at 3:05 pm

    #1587219

  • RE: Transaction log backup file is too big

    Beatrix Kiddo (2/12/2013)

    GilaMonster (2/12/2013)

    Beatrix Kiddo (2/12/2013)

    I know how to produce a backup file with the date in the name, but where does that leave me when I need it 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

    February 12, 2013 at 7:56 am

    #1587030

  • RE: Backward compatibility confusions

    Benki Chendu (2/12/2013)

    So, my question is, once we change the compatibility to a lower version, can we not backup that database and restore on a instance with a lower version.

    No....

    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 12, 2013 at 7:23 am

    #1587007

  • RE: Error attaching MdxStepByStep.mdf for SQL Server 2008 MDX Step by Step.

    GilaMonster (6/17/2012)

    When you attach, explicitly remove the ldf in the dialog (if they didn't provide it). Or use CREATE DATABASE ... FOR ATTACH_REBUILD_LOG

    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 12, 2013 at 6:58 am

    #1586991

  • RE: Transaction log backup file is too big

    Beatrix Kiddo (2/12/2013)

    I know how to produce a backup file with the date in the name, but where does that leave me when I need it to be overwritten each...

    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 12, 2013 at 6:55 am

    #1586989

  • RE: select statement is too slow

    I take it you didn't read the article I referenced, as it shows how to save and attach the graphical plan.

    Also, please post SQL 2008 questions in the SQL 2008...

    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 12, 2013 at 6:54 am

    #1586988

  • RE: Transaction log backup file is too big

    Beatrix Kiddo (2/12/2013)

    5) Schedule a regular backup of the transaction log, with overwrite

    will that work ok and solve my problem?

    As long as you never want to restore that log...

    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 12, 2013 at 3:29 am

    #1586904

  • RE: Lock Pages in Memory

    Do not set the min and max to the same value, it disables some of SQL's memory management and means that SQL won't reduce memory usage if the OS is...

    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 12, 2013 at 3:16 am

    #1586899

  • RE: select statement is too slow

    Execution plan please.

    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 12, 2013 at 3:13 am

    #1586897

Viewing 15 posts - 14,296 through 14,310 (of 49,552 total)