Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 49,552 total)

  • RE: SQL Server Management Studio 2017

    Please don't post multiple threads for the same problem.
    No further replies here please. Replies to  https://www.sqlservercentral.com/Forums/1889179/Upgrade-from-SQL-Server-2012-to-SQL-Server-2016-Inplace

    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

    July 28, 2017 at 2:08 am

    #1953151

  • RE: Upgrade from SQL Server 2012 to SQL Server 2016 Inplace

    Arjun SreeVastsva - Thursday, July 27, 2017 4:50 PM

    Hi,

    i have installed the ssms 17 and ssms 17.1 from given link
    but again...

    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

    July 28, 2017 at 1:38 am

    #1953147

  • RE: Consistency Errors on System Tables

    joliveira 19841 - Friday, July 28, 2017 12:53 AM

    GilaMonster - Thursday, July 27, 2017 1:05 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

    July 28, 2017 at 1:36 am

    #1953146

  • RE: Upgrade from SQL Server 2012 to SQL Server 2016 Inplace

    If it links to the SSMS installer, sure.
    The installation center (on the SQL 2016 installation media) has a link.

    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

    July 27, 2017 at 3:59 pm

    #1953125

  • RE: Upgrade from SQL Server 2012 to SQL Server 2016 Inplace

    Management studio is a separate install in SQL 2016.
    Download it (the 2016 installer has a link) and install it manually.

    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

    July 27, 2017 at 3:47 pm

    #1953123

  • RE: Consistency Errors on System Tables

    Lynn Pettis - Thursday, July 27, 2017 2:25 PM

    Gail, looking back at his response to my suggestion, it looks like the corruption...

    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

    July 27, 2017 at 3:00 pm

    #1953114

  • RE: Consistency Errors on System Tables

    You said that after getting the error in the upgrade you ran CheckDB with the repair_rebuild option.

    I'm asking you  to restore a backup from *before* you ran that...

    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

    July 27, 2017 at 1:05 pm

    #1953094

  • RE: SELECT & UPDATE statements resulting in different counts??

    Goalie35 - Thursday, July 27, 2017 9:22 AM

     HOWEVER, all "client_program_number" values in TableB will be the same for all records with that...

    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

    July 27, 2017 at 1:03 pm

    #1953092

  • RE: SQL Server STATISTICS

    Arsh - Thursday, July 27, 2017 8:31 AM

    But , don't the system objects physically exist in the resource database and only logically...

    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

    July 27, 2017 at 8:51 am

    #1953047

  • RE: SELECT & UPDATE statements resulting in different counts??

    Multiple rows in TableB for each claim number in TableA?

    If that's the case, you may need to fix the update so that there's a 1-1 match, as it's...

    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

    July 27, 2017 at 8:49 am

    #1953046

  • RE: need list of logins at the server level

    Snargables - Thursday, July 27, 2017 7:19 AM

    wow. confirmed. if an nt user does not exist is sql 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

    July 27, 2017 at 8:12 am

    #1953031

  • RE: SQL Server STATISTICS

    Arsh - Thursday, July 27, 2017 6:53 AM

    Hi,
    Thanks All for putting info on this .


    Gail , aren't 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

    July 27, 2017 at 7:02 am

    #1953005

  • RE: SQL Server STATISTICS

    Arsh - Thursday, July 27, 2017 4:13 AM

    . His point is , because new installation has new binaries , the meta data...

    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

    July 27, 2017 at 6:20 am

    #1952994

  • RE: Consistency Errors on System Tables

    GilaMonster - Wednesday, July 26, 2017 1:38 PM

    Can your try the following please?
    Restore the damaged backup to a test server
    Identify what table...

    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

    July 27, 2017 at 6:17 am

    #1952990

  • RE: DBCC CHECKDB lock the Databases

    Weekly would be good. Often enought that if you find corruption, you can fix it by restoring from backup and lose no data in the process.

    It doesn't lock...

    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

    July 27, 2017 at 1:49 am

    #1952954

Viewing 15 posts - 1,036 through 1,050 (of 49,552 total)