Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: Upgrading to SQL 2016 - Failures in SSRS

    Hi,
    Hoping that someone else had this issue in the meantime, and know of a work-around....

    Like I've mentioned before - we haven't changed anything within the application...
    Only...

  • RE: SQL 2016 security - sp_rename

    Anything else that I can check?

  • RE: SQL 2016 security - sp_rename

    Hi,
    Yes - double checked - do have dw_owner access.

    The query that we ran:

    Exec sp_rename 'Product.AgeCalculationBasis', 'Product.AgeCalculationBasiss'

    When I run it, it work just fine...

  • RE: Upgrading to SQL 2016 - Failures in SSRS

    Thanks - but for all of the results it's to change the code within the application.
    Which I can't do.
    I'm hoping for a security setting within SSRS config that...

  • RE: Upgrading to SQL 2016 - Failures in SSRS

    Thanks - but it worked with SSRS 2014. Something was changed within SSRS 2016 preventing the report to be displayed within the existing IFrames in ASP.

    I've searched, and...

  • RE: Filegroup backup questions

    GilaMonster (4/10/2015)


    Taking filegroup backups and restoring them to a consistent point requires log backups so that the DB can be brought to a consistent point in time. It's so that...

  • RE: Full Text Search, XML Indexes and Partitioning

    Any pointers on this?

  • RE: Over committed memory issue?

    Grant Fritchey (10/22/2014)


    That's really odd that the 120 compatibility level would do this. Have you applied any of the CUs?

    Hi,

    Yip - I've applied CU3.

    I will test again later this week....

  • RE: Over committed memory issue?

    Grant Fritchey (10/22/2014)


    My first thoughts were around parameter sniffing and issues there, especially if you're seeing changes in behavior based on changing the cardinality estimator (changing the compatibility level). But,...

  • RE: Over committed memory issue?

    Wait stats on the new Server:

    wait_type ...

  • RE: Over committed memory issue?

    Wait - tried it again to set the Compatibility level back to 110.

    Now the out of memory issue error is gone....

    Will double check the performance after a couple of extracts...

  • RE: Over committed memory issue?

    spaghettidba (10/22/2014)


    SQL Server 2014 has a new cardinality estimator that could lead to totally different execution plans. What compatibility level is the database?

    If you have good enough performance from the...

Viewing 12 posts - 1 through 12 (of 12 total)