Viewing 15 posts - 2,161 through 2,175 (of 2,917 total)
My next thought on things to check would be the IIS logs. If the PBI logs look fine, it is likely something in your IIS logs.
As a random guess (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.
October 15, 2019 at 9:15 pm
The resulting data type in your calculation is Numeric. I am thinking it is probably a floating point precision error that is giving you a near but slightly lower than...
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.
October 11, 2019 at 10:07 pm
That really depends on what you are trying to do. If it was me, and just guessing based on a lot of the variable names and trying to eyeball 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.
October 11, 2019 at 9:48 pm
What about something like this on your last query:
DECLARE
@i_from_date DATE = '2019-10-10'
, @i_to_date DATE = '2019-10-10';
WITH [object_changes]
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.
October 11, 2019 at 6:03 pm
I think this falls under an "it depends" window. What problem are you trying to solve? Is a single customer complaining about performance? are multiple clients? are all clients? are...
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.
October 8, 2019 at 8:37 pm
While I do agree with you, I've seen strange behavior like that before. I cannot think of or provide a case where it happened, but I've seen where performance improves...
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.
October 8, 2019 at 3:16 pm
Hello keneangbu,
My first piece of advice would be remove the cursor. Cursors are inherently slow. In your sample piece of code, I do not see a nice way to kill...
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.
October 7, 2019 at 9:49 pm
Just because it works in 1 browser doesn't mean it is not a configuration issue. Each browser may interpret the redirect differently or may even be ignoring it. I've been...
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.
October 4, 2019 at 2:50 pm
Error 5 is access is denied. My first step would be to check what user the SQL Server service is running under and make sure that account has permissions.
If this...
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.
October 4, 2019 at 2:38 pm
Going over to scdecade's solution and doing a bit of tweaking to it, would this not work:
DROP TABLE IF EXISTS test_table;
GO
CREATE TABLE [test_table]
(
[projectid]...
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.
August 22, 2019 at 3:07 pm
When I am installing SQL Server on a server, I usually copy the contents of the DVD to the machine. This allows me to install new instances quickly and easily...
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.
August 21, 2019 at 8:26 pm
I believe powershell can handle that, but most setup applications have silent options so powershell may be overkill for it.
That being said, I would be more concerned about why your...
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.
August 21, 2019 at 6:25 pm
If you are wanting to do it manually, I believe this query should help (may want to tweak it a bit to suit your specific needs):
SELECT
...
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.
July 30, 2019 at 8:12 pm
Sorry for the delayed response, but that is the method I would use. Basically exactly the code you have.
Then before you do the delete, do a quick check to make...
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.
July 22, 2019 at 7:29 pm
You would need the same logic in your delete. Your insert and delete logic should be the same or you will either insert data that isn't deleted (resulting in duplicate...
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.
July 11, 2019 at 5:26 pm
Viewing 15 posts - 2,161 through 2,175 (of 2,917 total)