Forum Replies Created

Viewing 15 posts - 7,576 through 7,590 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    I'm probably being cynical, but.... You realise that he's 2nd on the 'most active posters in the last 30 days' scoreboard?

    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
  • RE: Are the posted questions getting worse?

    Sean Lange (10/7/2014)


    GilaMonster (10/7/2014)


    Sean Lange (10/7/2014)


    The upside is the end of the list should be approaching fast. 😀

    He's up to 2007. 🙁

    Oh no. I assumed he must be working backwards....

    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
  • RE: Are the posted questions getting worse?

    I must re-read the Elric novels some time.

    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
  • RE: SQL login passwords that don't meet complexity requirements

    SkyBox (10/8/2014)


    What about running a trace on setting up a new user with enforce password policy enabled? Wonder if it would pick up the logic for meeting the password...

    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
  • RE: SQL login passwords that don't meet complexity requirements

    SQL stores passwords hashed, so you can't reverse that and get the password back.

    You can check the 'enforce policy' for logins and new passwords will have to match the domain...

    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
  • RE: Recommended memory settings

    Chapter 4: http://www.red-gate.com/community/books/accidental-dba

    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
  • RE: Log Shipping Files getting huge and difficult to transfer

    You're using the built in maintenance plan?

    What tasks in what order?

    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
  • RE: Log Shipping Files getting huge and difficult to transfer

    What, exactly, does your index maintenance job do?

    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
  • RE: SSMS2008 Debug Sysadmin Permissions

    SSMS debugger, a product which contains more bugs than it will ever help to find.

    I doubt most people use it because of the problems with 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
  • RE: InPlace update for Included Columns

    How are you seeing that it's a split update rather than an in-place?

    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
  • RE: Want to backup my db "here and now" without having the chance to restore a previous state

    cris651 (10/8/2014)


    The db is in 'simple' recovery mode and I'm taking full daily backups. I see that I'm able to restore db at any point in the past (that 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
  • RE: .SNAP files

    Jay@Work (10/7/2014)


    We have commvault simpana which apparently has a SQL Connector for backups.

    Perhaps this has detected the enterprise version and is utilising snapshots in order to do it's thing.

    Snapshots can't...

    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
  • RE: Can we install a 2012 cluster on a LPAR?

    http://www.acronymfinder.com/Information-Technology/LPAR.html

    Rank Abbr.Meaning

    LPAR Logical Partition (mainframes)

    LPAR Logic for Programming Artificial Intelligence and Reasoning (Conference)

    LPAR ...

    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
  • RE: Book example doesn't work, how come?

    r.morgan (10/7/2014)


    thanks everyone for your replies. I certainly understand the risk if anything goes wrong with it as it currently stands, but really it's my management that bears 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
  • RE: Book example doesn't work, how come?

    Jeff Moden (10/7/2014)


    GilaMonster (10/7/2014)


    The problem is that SQL 2000 has been out of support for years and there's a fair number of database consultants who won't work on SQL 2000...

    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

Viewing 15 posts - 7,576 through 7,590 (of 49,552 total)