Viewing 15 posts - 1,351 through 1,365 (of 2,917 total)
Like Pietlinden, I am not sure what you are trying to do, but one way you could do what you are asking would be with a cursors and 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.
March 5, 2021 at 2:04 pm
I agree with you ScottPletcher... I was just using examples (poorly) and bad terminology. By "unhappy" I just meant that performance would likely not be great. It is more 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.
March 4, 2021 at 5:10 pm
The "media" folder would be the folder that contains the installation media. So wherever you are running "setup.exe" from is the folder you would use for that.
IF you don't have...
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.
March 4, 2021 at 4:36 pm
You should be able to use the default installation folder UNLESS it is asking for the installation media folder in which case you will need to point it to 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.
March 4, 2021 at 4:11 pm
I can answer question 1 for you - other transactions on that database that select data may have no issues. Ones that change data will fail.
For question 2 - 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.
March 4, 2021 at 2:40 pm
I agree with Phil that it probably isn't a TFS issue.
Step 1 with debugging that for me would be to grab a different developer and have them try what 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.
March 4, 2021 at 2:02 pm
In the event you don't need unicode data in the body, you could convert it to a VARCHAR(MAX) as one thought.
Alternately, if you select the max length of the body...
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.
March 4, 2021 at 1:57 pm
Dimitri,
I want to apologize for sounding pessimistic about this. I do see where the tool could be beneficial. Where I work, it wouldn't be, but like you said, when 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.
March 4, 2021 at 1:46 pm
It is an interesting concept but it is still incredibly tricky to calculate. Lets say I do partitioning on my table and throw all of the "old" data onto slower...
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.
March 3, 2021 at 7:24 pm
That is a nice and easy one:
UPDATE [#partswithcompany]
SET [companyId] = [PARTS].[companyId]
FROM (SELECT [partNumber], MAX(companyID) OVER (PARTITION BY partnumber) AS companyID FROM [#parts]) AS PARTS
...
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.
March 3, 2021 at 5:02 pm
My opinion - I would install the R/Python stuff in SQL if you need it to store processed data in SQL OR you need it to process data that 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.
March 3, 2021 at 3:52 pm
The cause of having 58% sort operation is a 2 part question. The sort is probably due to something on your clustered index so the data needs to be ordered...
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.
March 3, 2021 at 2:47 pm
Service Broker (not sure it works in express but I expect so) would be another option and would be near real time, but may also be overkill. Linked server 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.
March 3, 2021 at 2:38 pm
I would do something like
SELECT appt_time + duration as end_time
BUT that assumes that the datatypes on those 2 columns can be added together. For example, if they...
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.
March 3, 2021 at 2:03 pm
I would start by comparing the data in the two systems. Pick a table and compare the values between the two. It COULD be that the user expected data, 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.
March 2, 2021 at 10:02 pm
Viewing 15 posts - 1,351 through 1,365 (of 2,917 total)