Forum Replies Created

Viewing 15 posts - 226 through 240 (of 320 total)

  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    I agree with Jim Murphy, but with relation to disks 5-8, i'm prefer raid 5 or 6, because with raid 10 I have more performance on writes on disk,...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Connection Issues

    if the instance of sqlexepress is present (like a service), then occurs some errors on uninstall!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Transactional Replication

    it's great question!!!

    thanks Gail!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: DB Mirroring

    the follow link, contain several steps for find out solution!

    http://msdn.microsoft.com/en-us/library/aa337361(v=SQL.90).aspx


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Index locks query in recurring sp

    khourshed (7/5/2011)


    yep, If I remove index and keep order by I have no problems with my sp (it executes in 0sec).

    If I dont remove index and remove order by ...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: DB Mirroring

    the following link: http://msdn.microsoft.com/en-us/library/ms189921.aspx for connections between servers of mirror!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: DB Mirroring

    post the error detail


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Index locks query in recurring sp

    if you remove index ix_cms_tblforumpost_1 and keep order by clause? do you have same effects?

    do you really need this index? some consolidation or just to order data?


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Transparent database encryption

    very good, question!!!!

    thanks Gail!!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Index locks query in recurring sp

    can you post execution plan? (actual + estimed plans)


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Index locks query in recurring sp

    what's the version of sql server?


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: DBCC CHECKDB errors

    maybe this link can help: http://support.microsoft.com/kb/923247/en-us#top


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: July 4

    i'm brazilian, but happy independence day for all!!!!!

    the SQLServerCentral isn't only about SQL Server Site, but too is a site to History and Fun!!!!!

    Good question!!!!

    😀


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Database attach issue

    the link bellow, can help you too!!!

    http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/f10908f9-5beb-4686-9f64-b4fa1ad1abd3


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Database attach issue

    GilaMonster (7/3/2011)


    You need to point the filestream directory somewhere too (and ensure that filestream is enabled)

    i agree with Gail!!!!

    like database is sample for training, is necessary to ensure that filestream...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

Viewing 15 posts - 226 through 240 (of 320 total)