Forum Replies Created

Viewing 15 posts - 15,721 through 15,735 (of 49,552 total)

  • RE: Stack Dumps

    Very hard to say. Could be a bug, could be memory corruption, could be other apps, could be other things 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 12, 2012 at 5:32 am

    #1558126

  • RE: Formatting date of birth using South African ID number

    Jason-299789 (11/12/2012)

    I didnt know that it was a government standard, but you would have thought they would have bit the bullet and updated thier IT systems 15-20 years ago when...

    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 12, 2012 at 5:31 am

    #1558125

  • RE: What Do You Want from SQL in the City?

    Bob Roby (11/9/2012)

    FYI, Steve Jones and "Gilamonster" Gail Shaw have a new fan.

    😀

    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 10, 2012 at 12:10 pm

    #1557921

  • RE: What Do You Want from SQL in the City?

    djackson 22568 (11/9/2012)

    GRIN For all those asking for it in Europe, bah humbug! Keep it here.

    You do know that Red Gate is based in the United Kingdom?

    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 10, 2012 at 12:09 pm

    #1557920

  • RE: TLog Shrink T-SQL Command

    The DBCC is the one that actually shrinks the log file.

    Please go and read that article.

    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 10, 2012 at 7:57 am

    #1557910

  • RE: Buffer Pool

    SQLSACT (11/10/2012)

    Does this mean that it removes the contents of the page?

    No. I already told you more than once what happens when checkpoint writes a page. I'm pretty sure I've...

    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 10, 2012 at 7:56 am

    #1557909

  • RE: TLog Shrink T-SQL Command

    The first one won't work on SQL 2008, the second one will. Otherwise they're the same, both bad forms of log mismanagement.

    Please read through this: http://www.sqlservercentral.com/articles/Administration/64582/

    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 10, 2012 at 12:30 am

    #1557886

  • RE: Tlog Shipping

    sdvandeslunt (11/9/2012)

    Hey, just curious, is there a T-SQL command to change the DB that is in NORECOVERY mode to be in READ-ONLY mode and then back to NORECOVERY mode.

    Yes,...

    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 9, 2012 at 6:27 pm

    #1557864

  • RE: Tlog Shipping

    George M Parker (11/9/2012)

    Standby actually brings the database online and makes it read only.

    Not quite. The DB is not brought online, if it was, further log backups would 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 9, 2012 at 6:24 pm

    #1557863

  • RE: Modifying a SQL 2000 maintenance plan -- and shrinking

    You should have two separate plans, one that does full backups and runs however often is required for full backups and a second plan that does log backups and runs...

    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 9, 2012 at 6:03 pm

    #1557861

  • RE: Out of memory exception

    It's not a bug. SSMS is a 32-bit application and as such can use no more than 2GB of memory, no matter what is available. Profiler does not display 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

    November 9, 2012 at 4:43 pm

    #1557853

  • RE: Execution Plan Reuse

    Huh?

    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 9, 2012 at 4:36 pm

    #1557851

  • RE: Poroblem with "CONTINUE_AFTER_ERROR"

    I would strongly recommend getting a fresh backup and restoring again. If a backup was restored with continue after error, it suggests there was an error somewhere in the restore...

    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 9, 2012 at 9:36 am

    #1557685

  • RE: How to pass a Microsoft certification [70-432]

    Good luck !!

    Seriously, the exam is not about luck. It's about knowledge and experience.

    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 9, 2012 at 9:27 am

    #1557680

  • RE: rebuild on clustered index

    Rebuilds are not going to affect how a DB grows. There's something else going on (check for manual shrinks in with the index rebuild job)

    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 9, 2012 at 9:00 am

    #1557662

Viewing 15 posts - 15,721 through 15,735 (of 49,552 total)