Forum Replies Created

Viewing 15 posts - 22,171 through 22,185 (of 49,552 total)

  • RE: index record count difference

    Sounds like you had some minor database corruption. Might be an idea to increase the frequency of checkDB for a while.

    Won't be nulls, because count(*) means count all rows regardless,...

    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

    November 16, 2011 at 2:58 am

    #1408312

  • RE: Internal Query Processor Error: The query processor encountered an unexpected error during execution.

    Call CSS (if it reoccurs). That's a bug of some sort.

    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

    November 16, 2011 at 12:50 am

    #1408279

  • RE: Index Maintenance

    Lexa (11/15/2011)

    Since there is no option to rebuild an index on a specific partition with option ONLINE=ON, would rebuilding index across all partitions but with option ONLINE=ON avoid blocking 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

    November 16, 2011 at 12:30 am

    #1408274

  • RE: Index Maintenance

    Dev (11/16/2011)

    I don't think it's a limitation...

    From the page you referenced:

    WITH (<single_partition_rebuild_index_option>)

    SORT_IN_TEMPDB, MAXDOP, and DATA_COMPRESSION are the options that can be specified when you...

    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

    November 16, 2011 at 12:27 am

    #1408273

  • RE: Single User Mode in Mirrored Database

    SQLback (11/15/2011)

    Thanks for bringing that up because I dont see that in our process. I am going to check with my Sr DBA about this. The whole reason we went...

    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

    November 16, 2011 at 12:12 am

    #1408268

  • RE: How to read the Execution plan :hehe:

    http://www.sqlservercentral.com/articles/books/65831

    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

    November 16, 2011 at 12:03 am

    #1408264

  • RE: Restore SS 2008 R2 database to SS 2008 R2 Standard Edition

    Edit: Express not Enterprise...

    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

    November 16, 2011 at 12:01 am

    #1408262

  • RE: Single User Mode in Mirrored Database

    SQLback (11/15/2011)

    It does have 980 files. Hence we run CheckDB on tables periodcially over the week.

    Btw, you do also run CheckAlloc an CheckCatalog along with CheckTable don't you?

    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

    November 15, 2011 at 2:59 pm

    #1408194

  • RE: Single User Mode in Mirrored Database

    SQLback (11/15/2011)

    It was confusing because in the log it said there were errors right after a message that the page has been repaired.

    The message in the log wasn't that 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

    November 15, 2011 at 2:57 pm

    #1408192

  • RE: How to verify SA password is not blank

    Try logging in with 'sa' and no password and screenshot the login dialog and the login failed error box?

    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

    November 15, 2011 at 2:54 pm

    #1408190

  • RE: Single User Mode in Mirrored Database

    SQLback (11/15/2011)

    I saw the following message in the logs indicating DB Mirroring did try to fix the page. May be it can only fix certain types of pages.

    Database mirroring successfully...

    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

    November 15, 2011 at 1:57 pm

    #1408167

  • RE: Single User Mode in Mirrored Database

    If you're willing to buy a book, the entire procedure is nearly laid out in SQL Server MVP Deep Dives 2 (http://www.manning.com/delaney), chapter 8. I do recommend you try 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

    November 15, 2011 at 1:03 pm

    #1408137

  • RE: Single User Mode in Mirrored Database

    You cannot. You'd have to break the mirror, set single user, repair and then recreate the mirror from scratch.

    That's why I'm suggesting page restores.

    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

    November 15, 2011 at 12:06 pm

    #1408111

  • RE: Single User Mode in Mirrored Database

    Steve Jones - SSC Editor (11/15/2011)

    First, please debug the consistency errors, and potentially call MS bfore you run this. If it cannot fix linkages, it will drop pages and remove...

    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

    November 15, 2011 at 11:52 am

    #1408098

  • RE: Single User Mode in Mirrored Database

    If you have full and log backups you can do page restores. If you've got Enterprise edition it'll be online with the DB completely accessible the entire time.

    One page 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

    November 15, 2011 at 11:51 am

    #1408097

Viewing 15 posts - 22,171 through 22,185 (of 49,552 total)