Forum Replies Created

Viewing 15 posts - 1,066 through 1,080 (of 2,917 total)

  • Reply To: Error when attempting to do initial backup for log shipping

    To me this looks like 2 different issues.  The first issue I expect is being caused by trying to take a full backup with INIT on top of an existing...

    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.

  • Reply To: SSRS MS Report Builder: How to repeat all item labels

    First thing I'd check is your data source.  Any chance that those values are in fact blank and not tied to the user?

    There are 2 ways to check this, 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.

  • Reply To: Top SQL Queries to Safeguard JIRA

    If you reach out to support, don't be too surprised if they can't help you too much.  I've had mixed results with support.  Sometimes they are amazing, sometimes they come...

    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.

  • Reply To: "Number of rows Read" vs "Actual Number of rows for all Executions"

    For those wondering, I checked and those do not appear to exist on 2008 R2. So thinking they were added in 2012.

    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.

  • Reply To: Top SQL Queries to Safeguard JIRA

    Jeff - that sounds like a configuration issue.  We have had our Jira instance running for years with nearly 500 users and the disk holding our database is only 50...

    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.

  • Reply To: Top SQL Queries to Safeguard JIRA

    Ours is heavily process oriented which is good and bad.  We have a lot of addons installed and roughly 50 automations set up.  It is a very powerful system, but...

    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.

  • Reply To: "Number of rows Read" vs "Actual Number of rows for all Executions"

    I don't have documentation on this, but from reading the text for both I interpret it as:

    Number of rows read <-- number of rows that needed to be read from...

    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.

  • Reply To: Top SQL Queries to Safeguard JIRA

    ZZartin - we are tracking a lot of things related to products we build such as which CVE's apply to them and what bugs are being worked on.  We also...

    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.

  • Reply To: Top SQL Queries to Safeguard JIRA

    On premise means we can limit access a lot better and we have control of the backups and the raw data (filesystem and database).  Plus on premise (Server) is cheaper...

    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.

  • Reply To: How to relate 2 tables

    What part are you having problems with?  You say you want to relate No with DocumentNo.  This feels trivial to do as long as those 2 columns ARE actually related.

    What...

    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.

  • Reply To: Database file movement due to drive space issue

    As a weird question - are C, E, and F the same PHYSICAL disk with different partitions on them?  If so, I would change that structure.  I came to 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.

  • Reply To: Top SQL Queries to Safeguard JIRA

    I feel you there.  But if that is what it takes to make the tool then that's what it takes.

    Also, I wouldn't say I like Jira... it has its purpose,...

    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.

  • Reply To: Top SQL Queries to Safeguard JIRA

    Below is my opinion, I do not work for Jira and have no knowledge of their back-end magic.

    I think one of the main reasons that you would want to do...

    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.

  • Reply To: SSRS Report Server Performance Monitoring

    I think it depends.  What are you looking to monitor?

    There are database monitoring tools and SSRS has a SQL Server back end so you may want to monitor that.  Or...

    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.

  • Reply To: Cursor inside a transaction

    As a random thought, I was looking at this chunk of code:

    SET @Sql = 'UPDATE ' + @TableName + ' SET ' + @CustSeqColName + ' =...

    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 - 1,066 through 1,080 (of 2,917 total)