Forum Replies Created

Viewing 15 posts - 26,866 through 26,880 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    I'm not sure I really want to get involved in this one (old friend), let's see if he does the prereq reading.

    He's got something using virtual memory (specifically the MemToLeave),...

    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 5, 2011 at 2:39 pm

    #1307717

  • RE: Downgrading backup log buffers from 1024K to 64K

    Google terms: Virtual memory fragmentation. MemToLeave

    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 5, 2011 at 2:37 pm

    #1307714

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/5/2011)

    Can anybody else lend a hand here?

    10 ft barge pole.

    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 5, 2011 at 2:34 pm

    #1307710

  • RE: Are Heaps Fragmented by Default

    CirquedeSQLeil (4/5/2011)

    John Mitchell-245523 (4/5/2011)

    CirquedeSQLeil (4/5/2011)

    a non-clustered index cannot be defragged without the presence of a clustered index.

    Jason, are you sure about this? My understanding is that you can rebuild...

    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 5, 2011 at 12:50 pm

    #1307653

  • RE: Are Heaps Fragmented by Default

    John Mitchell-245523 (4/5/2011)

    If your table only has inserts, with no deletes or updates, then you are not likely to experience a lot of fragmentation. So no, a heap 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

    April 5, 2011 at 12:48 pm

    #1307652

  • RE: please!!! very important

    ambo.php (4/5/2011)

    i try to check it

    but while run check and maintenace

    and click start jop

    it say : excuting jop step '0 unknown'

    Why are you running a maintenance plan? The error 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

    April 5, 2011 at 12:45 pm

    #1307650

  • RE: the case of missing indexes

    This, maybe? http://sqlskills.com/BLOGS/PAUL/post/Missing-index-DMVs-bug-that-could-cost-your-sanity.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

    April 5, 2011 at 11:33 am

    #1307614

  • RE: Simple load balance solution...or not

    Replication is not instantaneous. Is the delay acceptable?

    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 5, 2011 at 11:32 am

    #1307612

  • RE: please!!! very important

    That's not a SQL error. It's coming from some custom code in the database. Are the developers of the database available?

    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 5, 2011 at 11:23 am

    #1307607

  • RE: What are these table variables used for?

    UMG Developer (4/5/2011)

    GilaMonster (4/5/2011)

    Look at the time of the log entry. Look at the time the message gives.

    Guess I should read the whole message. 😉 I was assuming 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 5, 2011 at 11:22 am

    #1307606

  • RE: What are these table variables used for?

    WayneS (4/5/2011)

    I knew that for performance reasons, SQL does something that allows the last 50 used temp tables to be "reclaimed" by another process without having to go through 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

    April 5, 2011 at 11:00 am

    #1307588

  • RE: What are these table variables used for?

    UMG Developer (4/5/2011)

    GilaMonster (4/4/2011)

    UMG Developer (4/4/2011)

    I assume they are part of the CHECKDB process that runs when SQL Server starts.

    CheckDB doesn't run when SQL starts.

    Gila,

    Then what are all of these...

    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 5, 2011 at 10:58 am

    #1307587

  • RE: mirroring scenario

    djordan 4543 (4/5/2011)

    why do you think the log shipping needs same versions of sql?

    Because restore WITH STANDBY does not work in an upgrade scenario (primary lower version than secondary)....

    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 5, 2011 at 1:47 am

    #1307328

  • RE: SQLDump####.mdmp & txt filling C drive on a regular basis

    anthony.green (4/5/2011)

    I will raise a call with Microsoft to see if they can advise.

    They'll likely tell you to patch to SP4 and call them back if the problem persists. Maybe...

    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 5, 2011 at 1:43 am

    #1307327

  • RE: SQL Performance issue

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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 5, 2011 at 1:25 am

    #1307322

Viewing 15 posts - 26,866 through 26,880 (of 49,552 total)