Forum Replies Created

Viewing 15 posts - 45,196 through 45,210 (of 49,552 total)

  • RE: Need Help in SQL 2005 performance Tuning

    John Rowan (8/8/2008)

    As far as your SQL Server service account, you should generally run it under the local system account unless you SQL Server needs access to network resources.

    I don'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

    August 9, 2008 at 2:00 am

    #855638

  • RE: XP_cmdshell inside Trigger

    CrazyMan (8/9/2008)

    Thanks Gial

    I tought of this as well, since this is been updated or deleted...

    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

    August 9, 2008 at 1:55 am

    #855636

  • RE: Need Help in SQL 2005 performance Tuning

    Mike Alfa (8/8/2008)

    Not using /3 GB /userva was definitely unexpected suggestion which I think makes sense due to IIS running on this server.

    It has nothing to do with IIS. 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

    August 9, 2008 at 1:47 am

    #855631

  • RE: XP_cmdshell inside Trigger

    CrazyMan (8/9/2008)

    HI Lenny

    Its a java exe file that clears the cache, i saw permission, i have done this before, i have done this on...

    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

    August 9, 2008 at 1:42 am

    #855629

  • RE: 2 Transaction Log Files

    crever (8/8/2008)

    This is to allow you to stripe them for speed as well as place them on different drives as space becomes an issue.

    Multiple log files don'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

    August 8, 2008 at 1:51 pm

    #855517

  • RE: Need Help in SQL 2005 performance Tuning

    Do not use either /3GB or /userva if you are using AWE. You're asking for a unresponsive server.

    You do need to enable AWE if you want SQL to use more...

    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

    August 8, 2008 at 1:41 pm

    #855514

  • RE: XP_cmdshell inside Trigger

    Does the SQL server service account have rights to the directory c:\Bond\Bondcli?

    Does it have rights to execute tablePKDAO and do whatever that's supposed to do?

    What's going to happen if more...

    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

    August 8, 2008 at 1:28 pm

    #855501

  • RE: XP_cmdshell inside Trigger

    Can you post the trigger please?

    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

    August 8, 2008 at 10:26 am

    #855376

  • RE: How to Append value to an existing column value

    May I just observe that you have a rather poor database design there and that you may want to consider normalising it. It would certainly make adding or removing 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

    August 8, 2008 at 10:17 am

    #855367

  • RE: Error - The log cannot be rebuilt because the database was not cleanly shut down

    Pleasure

    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

    August 8, 2008 at 10:15 am

    #855364

  • RE: DBCC CHECKDB didn't repair the errors.

    Personally, I wouldn't run repair at all unless as an absolute last resort. If the corruption is in only nonclustered indexes, I would prefer to manually drop and recreate 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

    August 8, 2008 at 10:03 am

    #855347

  • RE: No More Katmai

    Miles Neale (8/7/2008)

    GilaMonster (8/7/2008)

    Peter Schott (8/7/2008)

    From what I've heard, if you just install the DB engine and the basic management tools, you should be OK. Don't install the parts 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

    August 8, 2008 at 9:59 am

    #855342

  • RE: DBCC CHECKDB didn't repair the errors.

    And definitly not to be run when CheckDB says that repair_rebuild is sufficint.

    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

    August 8, 2008 at 9:45 am

    #855324

  • RE: Error - The log cannot be rebuilt because the database was not cleanly shut down

    Yup.

    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

    August 8, 2008 at 9:44 am

    #855321

  • RE: Error - The log cannot be rebuilt because the database was not cleanly shut down

    In object explorer, right click the database, tasks -> Take offline

    To bring it online afterwards, right click the database, tasks -> Bring online

    It's not the same as detaching

    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

    August 8, 2008 at 9:26 am

    #855309

Viewing 15 posts - 45,196 through 45,210 (of 49,552 total)