Forum Replies Created

Viewing 15 posts - 2,821 through 2,835 (of 2,917 total)

  • RE: Service Broker concurrency post 2016 upgrade

    As a thought - did you have your 2012 DB in compatibility mode when you upgraded to 2016?

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SPID Status SUSPENDED with MaxDOP = 1? I need to look back...

    Jeffrey Irish - Wednesday, February 22, 2017 11:10 AM

    Thank you all for the quick replies.

    @sqlguru - Okay. I'd like to view that...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SPID Status SUSPENDED with MaxDOP = 1? I need to look back...

    Jeffrey Irish - Wednesday, February 22, 2017 10:25 AM

    Greetings to the Collective Minds of SQL Server Central! It has been a while...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: Performance improves after reboot

    RVO - Wednesday, February 22, 2017 8:01 AM

    Performance did not get substantially worse yet since last reboot on January 29th.
    My guess one...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: Performance improves after reboot

    Your original post was roughly 2 weeks ago.  

    I am assuming that performance is currently slower on that server, correct?

    My thoughts at this point would be...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: LCK_M_U delete 4999 rows.

    charliex - Friday, February 17, 2017 8:52 AM

    bmg002 - Friday, February 17, 2017 8:36 AM

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: LCK_M_U delete 4999 rows.

    charliex - Friday, February 17, 2017 8:17 AM

    bmg002 - Friday, February 17, 2017 8:04 AM

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: Upgrade to 2016 questions

    as1981 - Friday, February 17, 2017 7:47 AM

    Hello,

    Thanks for your advice.

    I will take a look at DxEnterprise.

    In terms of the Microsoft Data...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: LCK_M_U delete 4999 rows.

    What do you get from:
    SELECT count(*) FROM tablename 
    WHERE Column >= getdate()-5

    I am wondering if instead of doing a DELETE, you could select the rows you want...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: Upgrade to 2016 questions

    If you want to make your licensing costs a little bit lighter, you should look at DxEnterprise.  Same guys who made Polyserve back in the day.  It'll do the failover...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: Is that database is used by users or no?

    kucyk - Friday, February 17, 2017 7:20 AM

    ture, but only for  >= 2012 instances 🙂 thank you

    Extended events existed in 2008 as...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: Performance improves after reboot

    RVO - Thursday, February 16, 2017 9:58 AM

    Kevin,
    I was running this query yesterday
    and notice every 2-3 minutes it returns a records where...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: Can anyone recommend a working sample ETL package created with SSIS?

    halifaxdal - Wednesday, February 15, 2017 7:45 PM

    bmg002 - Wednesday, February 15, 2017 3:24 PM

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: Can anyone recommend a working sample ETL package created with SSIS?

    What is missing in the provided dtsx's from microsoft?
    I would imagine that if those were busted a lot more people would complain about them and get them working.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

Viewing 15 posts - 2,821 through 2,835 (of 2,917 total)