Forum Replies Created

Viewing 15 posts - 22,636 through 22,650 (of 49,552 total)

  • RE: Reindex failed primary file group not enough space

    Around 120% unless using Sort In TempDB, then it's just 100% plus metadata

    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

    October 29, 2011 at 4:50 pm

    #1400845

  • RE: Help using sqlcmd on remote clustered server

    No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1197764-391-1.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

    October 29, 2011 at 4:48 pm

    #1400844

  • RE: Failover Cluster & Domain Controller

    Get another server and make it the DC. Doesn't have to be a huge server.

    Cluster nodes need to be identical, so you shouldn't have the case where one node...

    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

    October 29, 2011 at 4:48 pm

    #1400843

  • RE: first attempt at automated backup plan

    And here's another article, a little more comprehensive. http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx

    Simple and full recovery models affect whether you'll be able to restore the DB to point of failure, or just the last...

    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

    October 29, 2011 at 9:21 am

    #1400831

  • RE: first attempt at automated backup plan

    sqlguy-736318 (10/29/2011)

    Based on what I've read a simple backup should be done frequently and a full backup should be done during off-peak times.  A simple backup is essentially an incremental...

    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

    October 29, 2011 at 8:58 am

    #1400827

  • RE: possible corruption due to i/o device error

    Do you have clean backups from before the crash?

    Do you have a chain of log backups from that full up until now?

    p.s. from the errors, the hardware is faulty. Moving...

    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

    October 29, 2011 at 4:28 am

    #1400817

  • RE: SQL Server 2008 memory usage exceeds configured Max Server Memory

    benjamin.reyes (10/28/2011)

    For example on one of my machines I have max memory set at 26,624 MB, which is my buffer size, the plan cache is an additional 4,408 MB. ...

    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

    October 29, 2011 at 4:26 am

    #1400816

  • RE: Massive IOs!

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    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

    October 28, 2011 at 2:05 pm

    #1400782

  • RE: Index scan vs. seek

    I'd like to see the exec plan with the scan 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

    October 28, 2011 at 12:11 pm

    #1400753

  • RE: Are the posted questions getting worse?

    Kiara (10/28/2011)

    Gianluca Sartori (10/28/2011)

    Apple computers can provide up to 1100 mA at 5 V through the USB port when an Apple peripheral or device is connected directly to the port...

    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

    October 28, 2011 at 11:46 am

    #1400738

  • RE: It's possible to have SQL Server 2005 and 2008 in the same pc running correctly?

    With all MS products, install them in release order.

    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

    October 28, 2011 at 11:28 am

    #1400731

  • RE: It's possible to have SQL Server 2005 and 2008 in the same pc running correctly?

    It's absolutely possible. At one point my desktop had SQL 2005, SQL 2008 and SQL 2008 R2 on it.

    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

    October 28, 2011 at 11:03 am

    #1400724

  • RE: Index scan vs. seek

    David Moutray (10/28/2011)

    Right click anywhere on your execution plan, and select show execution plan xml. The XML will open in a new query window. Then just copy and...

    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

    October 28, 2011 at 10:11 am

    #1400710

  • RE: SQL Server 2008 R2 File/Filegroup Restores

    What you need to do after that is then restore all the log backups taken on prod between when the backup of FileGroupC was taken and when that last backup...

    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

    October 28, 2011 at 10:10 am

    #1400709

  • RE: Trigger Help

    Then the SQL connection is being initiated from the server. The hostname is the name of the machine that requests the connection.

    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

    October 28, 2011 at 10:02 am

    #1400704

Viewing 15 posts - 22,636 through 22,650 (of 49,552 total)