Forum Replies Created

Viewing 15 posts - 33,781 through 33,795 (of 49,552 total)

  • RE: index covering and clustered index

    A clustered index contains every single column in the table in it's leaf level. Hence it is covering for any query.

    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

    February 27, 2010 at 8:22 am

    #1126093

  • RE: SQLServer Error: 824

    Be patient a bit please, I want to get a second opinion here.

    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

    February 27, 2010 at 4:59 am

    #1126054

  • RE: SQLServer Error: 824

    I strongly suggest that you restore MSDB from backup. You've got some nasty corruption there and repairing the system databases is not generally recommended.

    Restoring MSDB isn't the same as for...

    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

    February 27, 2010 at 4:06 am

    #1126046

  • RE: SQLServer Error: 824

    Good. So what's the output from CheckDB?

    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

    February 27, 2010 at 3:15 am

    #1126039

  • RE: SQLServer Error: 824

    Just to check, you do have backups of MSDB? You have been backing up the system databases?

    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

    February 27, 2010 at 2:40 am

    #1126035

  • RE: SQLServer Error: 824

    MSDBData is the name of the file, not the name of the database. If you query sys.databases, you'll see that database 4 (ID given in the error message) is called...

    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

    February 27, 2010 at 2:36 am

    #1126033

  • RE: SQLServer Error: 824

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

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

    Depending how bad this is, it may be necessary to restore from backups. Do...

    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

    February 27, 2010 at 2:06 am

    #1126029

  • RE: Are the posted questions getting worse?

    Jeff Moden (2/26/2010)

    I guess I'd get into trouble if I recommended that someone started Lithium treatment, huh?

    http://www.sqlservercentral.com/Forums/Topic873721-145-1.aspx

    Someone is a little over-sensitive to corrections and disagreements. Not just that thread, several...

    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

    February 27, 2010 at 2:02 am

    #1126028

  • RE: Are the posted questions getting worse?

    lmu92 (2/26/2010)

    Kit G (2/26/2010)

    Hey! You got it! Glad I could help out with your understanding of Cloud Computing. One other thing I should mention, the temperature of...

    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

    February 27, 2010 at 1:51 am

    #1126027

  • RE: Optimizations and Integrity check jobs failing

    Any other messages?

    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

    February 26, 2010 at 11:05 am

    #1125729

  • RE: index covering and clustered index

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

    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

    February 26, 2010 at 10:11 am

    #1125704

  • RE: Database Corruption Problem with CheckDB results - How bad is it?

    Could be just about anything anything in the IO stack

    Misbehaving filter driver (eg anti-virus)

    Buggy HBA drivers

    Faulty fibre switch

    Problematic SAN controller

    Glitch in SAN's write cache

    Failing drives

    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

    February 26, 2010 at 8:16 am

    #1125611

  • RE: Please Help - I've gone cross eyed.

    GSquared (2/26/2010)

    This kind of design can be done efficiently if you have the front end generate a GUID, instead of using a database-generated integer ID. The GUID can then...

    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

    February 26, 2010 at 8:01 am

    #1125599

  • RE: Please Help - I've gone cross eyed.

    allan.kendall (2/26/2010)

    I have had it suggested to me that I should/could use a transaction to carry this out. The transaction would submit the user form data first, then get 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

    February 26, 2010 at 8:00 am

    #1125598

  • RE: Please Help - I've gone cross eyed.

    Not a good design.

    The only way to ensure no duplicates and no blanks would be to hold an open transaction, locking enough rows that an incorrect id can't be inserted,...

    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

    February 26, 2010 at 7:28 am

    #1125571

Viewing 15 posts - 33,781 through 33,795 (of 49,552 total)