Forum Replies Created

Viewing 15 posts - 18,811 through 18,825 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/24/2012)

    GilaMonster (4/24/2012)

    Grant Fritchey (4/24/2012)

    I enjoyed it. A lot. The first third was better than the last two thirds. It's a first novel & you can tell, but 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

    April 25, 2012 at 1:32 am

    #1478730

  • RE: Server Performance

    Post the definition of DRTemp please.

    Avoid plan guides unless you really, really know what you're doing and why you're using them

    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

    April 25, 2012 at 1:28 am

    #1478726

  • RE: Are the posted questions getting worse?

    Revenant (4/24/2012)

    GilaMonster (4/24/2012)

    Steve Jones - SSC Editor (4/24/2012)

    I enjoyed that one. If you haven't read Space Prison or The Fringe Worlds, give them a try.

    Space Prison: This title 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

    April 25, 2012 at 1:28 am

    #1478725

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/24/2012)

    I enjoyed that one. If you haven't read Space Prison or The Fringe Worlds, give them a try.

    Space Prison: This title is not available 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

    April 24, 2012 at 5:44 pm

    #1478634

  • RE: Less DBMS dependant application: Oracle, SQL, MySQL and DB2 Less Migration Cost!

    Abrar Ahmad_ (4/24/2012)

    The team has devised a manual sequence/identity mechanism (physical tables with next ID generation and manual updates) for its transactional tables.

    I do hope your team tested that...

    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

    April 24, 2012 at 4:51 pm

    #1478620

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (4/24/2012)

    Also (if you can find them anywhere) these are three of the best sci-fi novels I ever read by an author nobody has ever heard 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

    April 24, 2012 at 4:45 pm

    #1478616

  • RE: Are the posted questions getting worse?

    Evil Kraig F (4/24/2012)

    Heh, you guys reminded me that I want to order up the final books in the Dresden series and finish that... 🙂

    Final? <sob>

    If it finishes where 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

    April 24, 2012 at 4:32 pm

    #1478611

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/24/2012)

    I enjoyed it. A lot. The first third was better than the last two thirds. It's a first novel & you can tell, but it was still a...

    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

    April 24, 2012 at 4:29 pm

    #1478610

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (4/24/2012)

    I just finished reading "Shadows In Flight", if you've ever read Orson Scott Card and like Bean better than Ender. Recommended.

    Intriguing... I loved Ender's...

    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

    April 24, 2012 at 4:23 pm

    #1478604

  • RE: Are the posted questions getting worse?

    #declare NewTopic;

    Grant, you mentioned the other day that you'd finished the book "Temporary Duty" This one http://www.amazon.com/Temporary-Duty-ebook/dp/B00531CPHC/? Good? Recommended?

    Looking for some good sci-fi again (space ships, interstellar travel, etc). 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

    April 24, 2012 at 3:45 pm

    #1478592

  • RE: Stored Procedure taking more time to execute (Sql Server 2005)

    Post them in this thread please.

    By sending them only to me you're requiring that only I help you.

    Edit, same with plans, please repost them here.

    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

    April 24, 2012 at 2:56 pm

    #1478554

  • RE: Stored Procedure taking more time to execute (Sql Server 2005)

    Which of those queries is the slow one?

    Yes please, table and index defs and please post the procedure.

    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

    April 24, 2012 at 2:08 pm

    #1478536

  • RE: Stored Procedure taking more time to execute (Sql Server 2005)

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    As a wild guess, maybe this: http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

    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

    April 24, 2012 at 1:42 pm

    #1478512

  • RE: sql server process memory has been paged out

    http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Chapter 4. Page 156.

    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

    April 24, 2012 at 12:47 pm

    #1478473

  • RE: Faultfinding possible I/O issues

    Both of the errors you've listed indicate there's some form of disk problem. Maybe contact the SAN vendor (assuming it's a SAN) and get them to check it out.

    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

    April 24, 2012 at 10:50 am

    #1478389

Viewing 15 posts - 18,811 through 18,825 (of 49,552 total)