Viewing 15 posts - 2,116 through 2,130 (of 2,917 total)
I was reading that document from microsoft too and I think I interpreted it differently (and incorrectly) than everyone else. I read it as the order is not guaranteed 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.
January 21, 2020 at 2:10 am
A different approach would be to tackle this at the application level. The application will grab the entire string from the database and split it in C# (or whichever language...
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 20, 2020 at 7:28 pm
Something to note - SOMETIMES using a CTE and temp table together will give better performance. SOMETIMES it is better to look at using JOINs instead of CTEs. And sometimes...
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 20, 2020 at 5:59 pm
Admingod - first, do not hijack posts. Your question is not related to the OP except for the fact that it is about partitioning.
Second, did you read the post 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 16, 2020 at 2:11 pm
Have you looked in BOL - LINK
From a quick google (as we don't use partitioning and it has been ages since I last looked at partitioning), null values 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.
January 13, 2020 at 8:19 pm
I am sure there are multiple ways to solve this problem, but one way (possibly not the most efficient) would be to add 3 more UNIONs, one per possible "blank"...
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 13, 2020 at 8:04 pm
My solution was a "dirty" one and not one that I'd recommend, but it was required to get the performance back that I needed: modify the hosts file.
Basically, if 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 10, 2020 at 4:27 pm
This looks like a crosspost over to Stack exchange for those curious:
But I am going to provide an answer as well to the best of my knowledge. Starting with...
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 10, 2020 at 2:19 pm
Doing a quick read over the code, it looks like the SQL you commented in should do similar things as the C# is. The only thing is that if 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 9, 2020 at 4:40 pm
Was just looking at the sample data you have in the attachment and none of those start at 4:00 AM or 4:00 PM. It looks like they start around 2:01...
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 8, 2020 at 6:41 pm
You sure you are opening the correct version of configuration manager? For example, if you install SQL Server 2017 and open SQL Manager 2012, you won't see it in there...
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 6, 2019 at 7:38 pm
I'm coming in to this debate a bit late, but my preference is to not let users build tables on LIVE systems if I can avoid it.
The developers where 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.
December 6, 2019 at 4:15 pm
Firstly, we have no access to your data, so I doubt you will get a lot of people helping with this. We cannot see any useful information about your data...
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 3, 2019 at 9:02 pm
Did a quick google of the error message and found this forum post:
Here, the problem was with permissions.
I also found this post:
https://kb.blackbaud.com/articles/Article/53466
which to me sounds like a space issue. 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.
December 3, 2019 at 6:10 pm
Are you going to have more than 2 million records in the table? If so, probably want that to be a bigint.
Heh... I know you meant...
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 3, 2019 at 5:42 pm
Viewing 15 posts - 2,116 through 2,130 (of 2,917 total)