Viewing 15 posts - 706 through 720 (of 2,917 total)
In the example you gave, the reason you are NOT seeing a duplicate when you have mother in there twice instead of father is because you used UNION. UNION will...
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.
January 7, 2022 at 9:50 pm
My advice - post the error message. I have a feeling it doesn't say the literal words "INSERT is wrong".
Now, I am also not 100% familiar with PostgreSQL, but I...
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.
January 7, 2022 at 5:32 pm
The query being executed for those curious and not wanting to click the link:
insert into [ExtractReports].[dbo].[TradeCodesDelete](PartID,Code,CodeTypeID,SourceTypeID,RevisionID,ZPLID,PartLevel,CreatedDate,FlagDelete)
----select count(1) from [ExtractReports].[dbo].[TradeCodesDelete]
---update [ExtractReports].[dbo].[TradeCodesDelete] set FlagDelete=2 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.
January 6, 2022 at 3:36 pm
My opinion - missing indexes report is only useful if you know the usage counts for those missing indexes AND the performance gain/hit by creating it.
For example, if you look...
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.
January 5, 2022 at 4:04 pm
Looking at this, it looks like a homework assignment, so I am not about to just give the answer in TSQL format, but I will try to lead you to...
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.
January 5, 2022 at 2:25 pm
My advice - reach out to Microsoft support. You pay for their support and those types of errors are things that should be covered by support.
The link you provided indicates...
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.
January 5, 2022 at 2:15 pm
My first question on this is - do you need to remove the subquery?. Is it performing badly? At what point will it perform "good enough"? Basically, do you need...
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.
January 4, 2022 at 10:34 pm
I think I am a bit confused by the question. My understanding of the "Generate Scripts" button is that it is used when performing an administrative related task and you...
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.
January 4, 2022 at 7:04 pm
The approach we take at our workplace is that service accounts do not have password expiration in place unless we believe the account has been compromised. The service accounts 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.
January 4, 2022 at 6:56 pm
What I would do is restore live to a dev environment. Once things are on the development environment, run the stored procedure a few times as is so you can...
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.
January 4, 2022 at 4:38 pm
HAHAHA... that is the running gag in the office actually! But the data in that database is critical to the company until the product goes EOL, yet it is running...
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.
December 30, 2021 at 8:27 pm
@ZZartin - that makes perfect sense. I do agree that the "urgent" fixes can go live without prior approval or code review, but we DO still do a post-release code...
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.
December 30, 2021 at 8:08 pm
I do not have the actual numbers but the scenario was that an application (outside my department) was updated which took down production. With production being down (the entire production...
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.
December 30, 2021 at 7:38 pm
I partially agree with you ZZartin.
I think there is no "one size fits all" solution, but I would also argue that with web-based content changes should be handled by the...
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.
December 30, 2021 at 5:20 pm
While I do agree that having the code go live quickly to fix a problem is nice, what if things go wrong? What if that code release halts production and...
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.
December 30, 2021 at 2:16 pm
Viewing 15 posts - 706 through 720 (of 2,917 total)