Forum Replies Created

Viewing 15 posts - 19,516 through 19,530 (of 19,563 total)

  • RE: Database Mirroring

    http://msdn.microsoft.com/en-us/library/bb677167.aspx

    this microsoft provided link states that they were erroneous in which versions support automatic page repair.

    both standard and Enterprise editions support it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 9, 2009 at 10:16 am

    #1022523

  • RE: Database Mirroring

    http://msdn.microsoft.com/en-us/library/bb677167.aspx

    this microsoft provided link states that they were erroneous in which versions support automatic page repair.

    both standard and Enterprise editions support it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 9, 2009 at 10:16 am

    #1022522

  • RE: Database Mirroring

    http://msdn.microsoft.com/en-us/library/bb677167.aspx

    this microsoft provided link states that they were erroneous in which versions support automatic page repair.

    both standard and Enterprise editions support it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 8, 2009 at 3:55 pm

    #1021996

  • RE: Database Mirroring

    http://msdn.microsoft.com/en-us/library/bb677167.aspx

    this microsoft provided link states that they were erroneous in which versions support automatic page repair.

    both standard and Enterprise editions support it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 8, 2009 at 3:13 pm

    #1021962

  • RE: OS Disk Defrag

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 8, 2009 at 2:00 pm

    #1021900

  • RE: OS Disk Defrag

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 8, 2009 at 2:00 pm

    #1021899

  • RE: OS Disk Defrag

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 8, 2009 at 1:59 pm

    #1021897

  • RE: OS Disk Defrag

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 8, 2009 at 1:53 pm

    #1021894

  • RE: OS Disk Defrag

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 8, 2009 at 1:48 pm

    #1021892

  • RE: OS Disk Defrag

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 8, 2009 at 1:47 pm

    #1021891

  • RE: OS Disk Defrag

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 8, 2009 at 1:46 pm

    #1021887

  • RE: OS Disk Defrag

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 8, 2009 at 1:46 pm

    #1021884

  • RE: DNS solution for sql server running in named instance or different port

    We use a similar setup for the explicit purpose of being able to easily move databases and instances from one server to another should the need arise.

    I would recommend that...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 7, 2009 at 1:47 pm

    #1021311

  • RE: partitioning to help queries on large table slowing insert times

    I agree with Lynn on the NOLOCK hint. Too many places have mandated the NOLOCK on all Select statements. This is one that should have a proceed with...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 1, 2009 at 4:45 pm

    #1018794

  • RE: Is it Possible

    Forgot to add to the post that DB optimization is not found in the filegroup solution alone - but can be a piece of the puzzle. In short, I...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 1, 2009 at 4:37 pm

    #1018791

Viewing 15 posts - 19,516 through 19,530 (of 19,563 total)