Forum Replies Created

Viewing 15 posts - 706 through 720 (of 49,552 total)

  • RE: Data row does not have a matching index row in the index

    Too-wide an index WILL NOT cause this error. SQL does not cause its own corruptions.
    Too-wide an index will just cause inserts to fail. (and an insert will not partially...

    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 19, 2017 at 6:57 am

    #1964337

  • RE: Windows Server 2012

    yrstruly - Wednesday, October 18, 2017 12:10 AM

    Hi 

    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 18, 2017 at 12:50 pm

    #1964265

  • RE: Migration from SQL 2005 to 2012

    John.Garvey - Tuesday, October 17, 2017 10:54 AM

    Please also be aware that most likely you will need to restore and backup this 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

    October 17, 2017 at 1:19 pm

    #1964095

  • RE: Suspect production database

    I'm not asking you to test it on a test database (and besides, getting a test DB into SUSPECT is not trivial). You have a suspect database. Please try 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 13, 2017 at 1:10 pm

    #1963633

  • RE: Recovery Pending Status

    (off

    Johnson Welch - Friday, October 13, 2017 12:51 AM

    In my case it helped to set it to "Local System" (as a workaround)....

    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 13, 2017 at 1:33 am

    #1963505

  • RE: Migration from SQL 2005 to 2012

    dva2007 - Friday, October 6, 2017 4:42 AM

    Regarding 2012 i came into this very late and organisation made the decision to buy...

    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 6, 2017 at 11:31 am

    #1962685

  • RE: reduce max server memory

    sqlguy80 - Wednesday, October 4, 2017 5:12 PM

    Hi All,
    So we got alerted that the sql server was using 90% memory.

    Normal, expected, desired...

    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 5, 2017 at 2:50 am

    #1962415

  • RE: Is this a good idea or a really, really dumb one?

    Ozymandias_EBON - Wednesday, October 4, 2017 8:24 AM

    stevenb 14609 - Tuesday, October 3, 2017 1:21 PM

    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 4, 2017 at 3:34 pm

    #1962368

  • RE: Are the posted questions getting worse?

    And here's the download link for 2017. https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/10/02/sql-server-2017-available-for-download/

    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 2, 2017 at 2:30 pm

    #1961957

  • RE: Are the posted questions getting worse?

    Thom A - Monday, October 2, 2017 7:57 AM

    Anyone got any idea what time 2017 goes up, or is it just (at...

    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 2, 2017 at 10:30 am

    #1961913

  • RE: Best Practice to Write a View for 3rd Parties

    Why are you bothering with a view in the first place? What are you gaining over just giving the other system read access to the tables?

    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

    September 30, 2017 at 9:00 am

    #1961775

  • RE: Best Practice to Write a View for 3rd Parties

    BOR15K - Saturday, September 30, 2017 3:50 AM

    But in tables like list of countries, cities or in my case - fee...

    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

    September 30, 2017 at 4:53 am

    #1961769

  • RE: Large SQL server under utilizing memory

    aman4God - Friday, September 29, 2017 3:25 PM

    GilaMonster - Friday, September 29, 2017 2:47 PM

    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

    September 29, 2017 at 3:30 pm

    #1961749

  • RE: Alter Table....Add Column

    Arsh - Friday, September 29, 2017 8:35 AM

    I wonder how a row length cannot be more than 8KB ? Text type...

    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

    September 29, 2017 at 2:53 pm

    #1961745

  • RE: Best Practice to Write a View for 3rd Parties

    kevaburg - Friday, September 29, 2017 8:53 AM

    Fair enough...just read up on it and realised my mistake.  That said, what a daft...

    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

    September 29, 2017 at 2:49 pm

    #1961743

Viewing 15 posts - 706 through 720 (of 49,552 total)