Forum Replies Created

Viewing 15 posts - 13,906 through 13,920 (of 49,552 total)

  • RE: DBCC CheckTable returns following results, best way to deal with this?

    Yeah, most people aren't convinced until something fails catastrophically. Make sure your backups are good.

    Also, it isn't necessarily the physical drive. Could be the firmware, drives, switch, cache, any filter...

    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

    March 13, 2013 at 1:36 am

    #1596381

  • RE: DBCC CheckTable returns following results, best way to deal with this?

    aurato (3/12/2013)

    Would you recommend migrating the databases on this disk to a different drive?

    Well, ask yourself, would you leave important information on a drive that's giving repeated problems?

    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

    March 12, 2013 at 2:38 pm

    #1596272

  • RE: DBCC CheckTable returns following results, best way to deal with this?

    IO subsystem problems in almost all cases. Could be as simple as a write cache that's not battery backed, could be misbehaving filter drives in the IO stack, etc.

    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

    March 12, 2013 at 10:45 am

    #1596148

  • RE: SQL Server error - Cannot Open User Default Database error 4064

    Is the user a member of any groups that have logins in the database with different default databases?

    In fact, check all the logins, see if any have a default database...

    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

    March 12, 2013 at 10:43 am

    #1596145

  • RE: DBCC CheckTable returns following results, best way to deal with this?

    Drop the indexes 'IX_Advertise_BrandCopy_Price_Stock' and 'IX_ITEMS_ADVFLAG_PARETN_PRICE_STOCK' (on the table 'Items') and recreate them. Don't rebuild them, drop and recreate.

    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

    March 12, 2013 at 10:41 am

    #1596142

  • RE: SQL Server error - Cannot Open User Default Database error 4064

    Double-check the login's default database. Error message is saying it's not available.

    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

    March 12, 2013 at 8:46 am

    #1596057

  • RE: DBCC CheckTable returns following results, best way to deal with this?

    Please run the following and post the full, complete and unedited output.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

    March 12, 2013 at 8:39 am

    #1596052

  • RE: OPTIMIZE FOR UNKNOWN Query Hint

    Sounds like you're trying to do this:

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

    If you are, optimise for unknown is not going to help much. All it does is have the optimiser make row estimations based just...

    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

    March 12, 2013 at 8:24 am

    #1596041

  • RE: OPTIMIZE FOR UNKNOWN Query Hint

    In short it just doesn't use parameter sniffing to estimate the rows that will be affected by the specific parameter values.

    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

    March 12, 2013 at 6:56 am

    #1595966

  • RE: Why do some of these procedure calls have syntax errors?

    Tobar (3/12/2013)

    But I am still left with my question, better defined now to be sure, why does SQL Server not allow a function as a parameter?

    Why can I not create...

    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

    March 12, 2013 at 6:35 am

    #1595954

  • RE: DR/HA proposal

    Sen1 (3/11/2013)

    I need to write DR/HA proposal any suggestions?

    Do you have any HA/DR experience?

    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

    March 12, 2013 at 6:01 am

    #1595928

  • RE: Why do some of these procedure calls have syntax errors?

    T-SQL syntax rules, the parameter to a procedure cannot be a function.

    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

    March 12, 2013 at 5:59 am

    #1595927

  • RE: Differential Backup Blocking Trans Log Backup

    KumarSQLDBA (3/12/2013)

    There's a special case where a backup that has to pick up bulk-logged extents will take a file lock which could block a checkpoint operation – but DML is...

    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

    March 12, 2013 at 4:47 am

    #1595894

  • RE: Encryption doubts

    Who are you protecting the data against?

    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

    March 12, 2013 at 4:32 am

    #1595893

  • RE: Negative Available Space for tempdb

    Run DBCC UPDATEUSAGE, see if it fixes anything.

    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

    March 12, 2013 at 4:23 am

    #1595889

Viewing 15 posts - 13,906 through 13,920 (of 49,552 total)