Viewing 15 posts - 826 through 840 (of 2,917 total)
I agree with Grant here. I find that MOST of the time when I think a Cursor is required, it is just that I have been doing too much .NET...
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.
November 24, 2021 at 2:16 pm
My understanding - even on a SAN the performance benefits may be lost. The idea is to have it on separate physical disks. once you start working with virtual disks,...
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.
November 23, 2021 at 8:33 pm
I agree with Joe on this one and would disagree with aaron.reese. Parsing a string like that in SQL is going to be painful and adding more logic into 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.
November 23, 2021 at 4:30 pm
If you are getting the results you need, is there a reason to go with DISTINCT instead of GROUP BY?
If you absolutely need to remove the DISTINCT and replace it...
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.
November 19, 2021 at 7:56 pm
I can think of a few approaches, but my recommendation is to scrap that process and instead use stored procedures and have your code call the stored procedure instead. 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.
November 19, 2021 at 7:46 pm
What I am expecting is happening is that the datatype of BillingRateB is going to be something like VARCHAR and the value is something along the lines of '' 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.
November 18, 2021 at 9:29 pm
Might be a silly question, so feel free to ignore this, but do you really need the DATE and TIME in 2 different columns? I have seen systems do 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.
November 18, 2021 at 7:14 pm
As a guess - I would say that the report is rendering and/or calculating out the number of pages it needs which is why you need to wait. When 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.
November 18, 2021 at 7:08 pm
From looking at what you have, I think I see what is wrong. You are inserting into AllData the columns, but since you are not specifying a column to insert...
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.
November 18, 2021 at 2:17 pm
Another way to optimize the sort operation would be to remove it by removing your ORDER BY statement. If you don't order the data, no sorting would be required.
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.
November 17, 2021 at 2:54 pm
That is a painful problem to solve. The other problem that can arise is how many columns do you need to make to handle current state and future state?
My opinion...
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.
November 17, 2021 at 2:42 pm
To me that sounds like when the disk had bad sectors which resulted in data getting corrupted in the system databases and possibly user databases.
First, I would put it into...
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.
November 16, 2021 at 3:58 pm
I would start by reaching out to Microsoft for support.
They may suggest that you rebuild master, but you will lose all of your logins and roles and other objects stored...
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.
November 16, 2021 at 3:45 pm
I am thinking you mean DLL not DDL. Wireshark would probably help determine if it is network related, and I am still leaning towards something on the network stack between...
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.
November 16, 2021 at 2:17 pm
With the view, if the indexes on the table are "good enough" for it, then you could still use the view without the index on it. This would allow 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.
November 15, 2021 at 9:52 pm
Viewing 15 posts - 826 through 840 (of 2,917 total)