Forum Replies Created

Viewing 15 posts - 2,896 through 2,910 (of 49,552 total)

  • RE: Drop the table and add the column

    Script out the CREATE TABLE from management studio, along with all indexes and constraints. Use SELECT INTO to put the data into a temp table. Drop or rename the 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

    June 27, 2016 at 4:13 am

    #1886992

  • RE: Drop the table and add the column

    Suggestions for what?

    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

    June 27, 2016 at 3:52 am

    #1886989

  • RE: Rebuilding Indexes

    That is serious overkill. It's extremely unlikely that you need to rebuild all indexes every time. Look up Ola Hallengren's index maintenance script (or go to http://ola.hallengren.com/) and use that.

    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

    June 27, 2016 at 2:48 am

    #1886979

  • RE: CPU Usage 100%

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    June 27, 2016 at 2:44 am

    #1886977

  • RE: Need algorithm for Complex looping logic

    JoNTSQLSrv (6/26/2016)

    it does nt work 🙁

    Be specific. What exactly is wrong? Wrong results? If so, where and what should the results be? Throws an error? If so, 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

    June 26, 2016 at 11:54 am

    #1886945

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (6/26/2016)

    I like the sentiment, but I don't think there is any realistic chance of this having any effect. The votes have been counted; the results are in. Accept...

    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

    June 26, 2016 at 10:50 am

    #1886942

  • RE: Adding myself as Admin via DAC - service restart necessary?

    Steve Jones - SSC Editor (6/25/2016)

    This is a single threaded connection available for adminstrators that doesn't get resources blocked by long running queries.

    Kinda true. It's got its own scheduler...

    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

    June 25, 2016 at 10:52 am

    #1886902

  • RE: Adding myself as Admin via DAC - service restart necessary?

    If you're talking about situations where there's no sysadmin login, or the only one is sa and the password has been forgotten, then you don't need the DAC at all....

    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

    June 25, 2016 at 10:50 am

    #1886901

  • RE: Cannot login to SQL 2008 Express SP3 remotely - Error 1326 - Incorrect user/pass

    diego_vizia (6/24/2016)

    It's really strange that it shows incorrect username/password when the server is offline.

    That's why I think you're connecting to something other than what you expect.

    This is what...

    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

    June 24, 2016 at 3:05 pm

    #1886853

  • RE: Are the posted questions getting worse?

    Sean Lange (6/24/2016)

    Ugh....just needing to share this unbelievably ridiculous mess I just stumbled across.

    create view [dbo].[getNewID] as select newid() as new_id;

    Really? A view to get a guid???

    But wait...it gets even...

    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

    June 24, 2016 at 3:04 pm

    #1886852

  • RE: Are the posted questions getting worse?

    Ed Wagner (6/24/2016)

    GilaMonster (6/24/2016)

    Luis Cazares (6/24/2016)

    I'm sorry, is there any country that can give me good news?

    Yes, for a change we do. Our High Court has ruled 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

    June 24, 2016 at 7:51 am

    #1886743

  • RE: Cannot login to SQL 2008 Express SP3 remotely - Error 1326 - Incorrect user/pass

    DNS redirects? Ask your network admin for help, it does sound like the connection's going to a different instance somewhere.

    Also, check you haven't made a spelling mistake in the server...

    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

    June 24, 2016 at 7:45 am

    #1886740

  • RE: Are the posted questions getting worse?

    Luis Cazares (6/24/2016)

    I'm sorry, is there any country that can give me good news?

    Yes, for a change we do. Our High Court has ruled that the appeal against 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

    June 24, 2016 at 7:36 am

    #1886735

  • RE: Are the posted questions getting worse?

    Ed Wagner (6/23/2016)

    Phil Parkin (6/23/2016)

    Jeff Moden (6/23/2016)

    On the "Brexit" thing, the folks in GB really need to consider the ramifications to their automotive industries. The EU has a 10%...

    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

    June 24, 2016 at 1:52 am

    #1886661

  • RE: Should I enable DAC?

    HappyGeek (6/23/2016)

    However Microsoft say; "On cluster configurations, the DAC will be off by default.", I have no way of verifying whether this is true or MS myth!

    True by implication,...

    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

    June 23, 2016 at 3:16 am

    #1886466

Viewing 15 posts - 2,896 through 2,910 (of 49,552 total)