Forum Replies Created

Viewing 15 posts - 61 through 75 (of 5,841 total)

  • RE: SQL 2012 Log shipping. D.B. record change not applied to secondary

    What you state is not possible if log shipping is working correctly. And I will go so far as to say it won't be a SQL Server bug either because...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Ghost Process attacks again

    Definitely recommend getting a (good) consultant certified to work for you so they can be on standby to jump on as soon as the event starts occurring again. There are...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Ghost Process attacks again

    There are a large number of things that could be in play here. I don't know that a forum is the place for them because it is an intermittent problem....

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Performance issues post migration to 2016...looking for recommendations (Resolved)

    I ignore what admins/devs tell me when digging into an outage scenario like this. The data I collect will do all the talking necessary almost without exception. And if you...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: DBCC CheckDB produced errors

    GilaMonster - Tuesday, January 23, 2018 11:48 AM

    Corruption is usually related to problems with the IO subsystem.

    And those usually related to not...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Efficient way of mirroring tables from one sql instance to another

    ffarouqi - Tuesday, January 23, 2018 9:40 AM

    TheSQLGuru - Friday, January 19, 2018 12:50 PM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Performance issues post migration to 2016...looking for recommendations (Resolved)

    1) Glad you got it fixed.

    2) "...I didn't even know where to begin..." - That is actually the single most important thing on this entire thread, and is...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Performance issues post migration to 2016...looking for recommendations (Resolved)

    If you want to get your problems resolved ASAP, hire a professional tuning expert. You have given us essentially nothing to go on to help resolve what sounds like severe,...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Stored Procedure Dynamic SQL using sp_executesql Not working

    Luis Cazares - Monday, January 22, 2018 8:46 AM

    Why would you create a table, insert rows and then select the new table?
    Why...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: In-Memory tables candidate

    89netanel - Sunday, January 21, 2018 3:24 AM

    Hello All,
    how can i decided which table is candidate from disk table to in-memory table?
    and...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Efficient way of mirroring tables from one sql instance to another

    Log shipping is easiest, BY FAR. But like mirroring it does everything. 

    Since it sounds like you want a "SMALL" subset of tables, I would just create simple triggers...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Memory pressure and SQL errors

    Does your HOST and VM have a good bit more than 128GB of RAM available/reserved for the VM? If not that would be priority #1 in my book (unless you...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Memory pressure and SQL errors

    Grant Fritchey - Thursday, January 18, 2018 6:00 AM

    TheSQLGuru - Wednesday, January 17, 2018 4:48 PM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: UPDATE() function in a trigger

    Jeff Moden - Thursday, January 18, 2018 8:27 AM

    Aaron N. Cutshall - Thursday, January 18, 2018 7:59...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: UPDATE() function in a trigger

    Just making statements of fact - nothing more sadly for you.

    I think you should spin it up in XML in the engine inside the trigger. I hear that...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 15 posts - 61 through 75 (of 5,841 total)