Forum Replies Created

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

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/20/2011)

    GilaMonster (7/20/2011)

    Jeff Moden (7/20/2011)

    I understand that Gail Shaw will be co-presenting with you...

    Yup, Grant and I are doing comed^H^H^H^H^H execution plans as a precon on the Monday.

    What are...

    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

    July 20, 2011 at 8:06 am

    #1355637

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/20/2011)

    I understand that Gail Shaw will be co-presenting with you...

    Yup, Grant and I are doing comed^H^H^H^H^H execution plans as a precon on the Monday.

    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

    July 20, 2011 at 7:56 am

    #1355617

  • RE: Filegroups, HV, one underlying raid array

    Jannie-186227 (7/19/2011)

    If you add a filegroup and I assume you'd hook up a file to it. You get the benefit of more IO threads.

    SQL uses all threads to write 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

    July 20, 2011 at 1:02 am

    #1355390

  • RE: trace flag 815

    Jannie-186227 (7/19/2011)

    Get the address and details of the database and the associated LUN on SAN.

    Check for path failovers, find out how the caching is being done.

    Don't say it's an error...

    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

    July 20, 2011 at 1:01 am

    #1355389

  • RE: Memory Usage

    adams.squared (7/19/2011)

    This one is not a dedicated SQL server though.

    If that's the case then you need to drop SQL's max memory down until there's enough free memory 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

    July 19, 2011 at 4:00 pm

    #1355203

  • RE: undo changes to a stored procedure

    I still can't see anything odd. No blank lines, no right-padding...

    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

    July 19, 2011 at 3:56 pm

    #1355201

  • RE: undo changes to a stored procedure

    What whitespace where? Can't see anything odd.

    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

    July 19, 2011 at 3:48 pm

    #1355197

  • RE: Database can't be recovered? Any help would be appreciated!!!

    GSquared (7/19/2011)

    Have you tried the create database options that rebuild the log file?

    Create Database For Attach_Rebuild_Log

    (Check MSDN or BOL for the full syntax.)

    Unlikely to work unless the DB was cleanly...

    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

    July 19, 2011 at 3:47 pm

    #1355196

  • RE: Database can't be recovered? Any help would be appreciated!!!

    halifaxdal (7/19/2011)

    Sorry I have to go, I am being pulled out to another case, I haven't finished reading the "http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/"

    I will read it once I am back, but can you...

    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

    July 19, 2011 at 3:46 pm

    #1355195

  • RE: Database can't be recovered? Any help would be appreciated!!!

    It is not a good idea to try and upgrade a damaged file. Not got a 2000 server to attach them to?

    Try this

    http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

    If it fails, tell us exactly at what...

    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

    July 19, 2011 at 2:49 pm

    #1355167

  • RE: Locking/Blocking issues

    Have you tried activity monitor in SSMS?

    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

    July 19, 2011 at 10:01 am

    #1354937

  • RE: Error encountered during creation of databases: CREATE FILE encountered operating system error 5(Access is denied.)

    sqlapprentice (7/19/2011)

    And I am sure both SQL Server service account and SQL Server agent service account have full control privileges on both folder 'S:\SQL\userdbdata01\' and 'S:\SQL\userdblog01\'.

    Do you think you're sure...

    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

    July 19, 2011 at 9:57 am

    #1354931

  • RE: Can't understand why I'm getting index scans

    Ninja's_RGR'us (7/19/2011)

    count(*) makes any index covering (assuming no join / where).

    Indeed. My guess here is that it's the join that's the main factor in the changed plan.

    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

    July 19, 2011 at 9:35 am

    #1354910

  • RE: Locked/Blocked Server

    Is there a question 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

    July 19, 2011 at 9:24 am

    #1354901

  • RE: Can't understand why I'm getting index scans

    Ninja's_RGR'us (7/19/2011)

    Also the estimated # of rows returned must be really low (% of whole table) for the seek to be used as the plan.

    Unless the index is covering. If...

    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

    July 19, 2011 at 9:23 am

    #1354899

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