Viewing 15 posts - 961 through 975 (of 2,917 total)
First, I'd recommend posting some DDL so we can consume your data and do some tests. Nothing worse than untested code, right?
Looking at the image, a potential solution would be...
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 24, 2021 at 4:12 pm
Yes, my approach will filter the whole data set. If you need it filtered in just one place, then my suggestion won't help you and will actually make things worse.
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 24, 2021 at 3:44 pm
I like the approach that everyone else is offering, but thought I'd chime in to describe mine in a bit more detail.
My suggestion was to change the data source from...
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 24, 2021 at 3:34 pm
Specifically this section which indicates what triggers an auto-update on the statistics:
- There was a data change on an empty table.
- The number of rows in the table was...
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 23, 2021 at 7:59 pm
I think that is the joys of the SQL engine. USUALLY logical reads are slow operations and having more of them will result in longer elapsed time. That is likely...
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 23, 2021 at 6:16 pm
As a thought on this, as you can't push this to the stored procedure, what about if you push it to the TSQL?
What I mean is in the SSRS package,...
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 23, 2021 at 4:44 pm
Another thing to check is linked servers. If a linked server connection connects to that instance as a user who has permission to drop and create objects AND you 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.
August 23, 2021 at 4:28 pm
Experts correct me if I am wrong, but what I am seeing is that you have no filter predicates on the non-clustered index scan. The filter is on the clustered...
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 23, 2021 at 4:23 pm
I think the first step is finding the right tool for the job. For doing analytics, I would recommend an analytics reporting tool (SAS Visual Analytics, PowerBI, Excel, Tableau, etc). ...
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 20, 2021 at 10:12 pm
As a thought - what about instead of trying to build the data set up to contain all possible combinations of summing up the data, you do it in 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.
August 20, 2021 at 7:58 pm
Like TangoVictor, all of my stuff is on-prem as well, so my tips and advice may be useless.
Things I'd check (if possible) are logs on the server. I'm thinking 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.
August 20, 2021 at 7:50 pm
I agree 100% with latkinson above. I know when I attended my first PASS Summit I was VERY new as a DBA and all my learning was from google 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.
August 20, 2021 at 2:24 pm
I agree with Jeff here on not using a bat file for this UNLESS you are on SQL Express. If you are on SQL Standard or higher, then I would...
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 19, 2021 at 4:38 pm
I see 2 potential options here:
1 - contact WooCommerce to see if they can fix their data export to be in proper JSON format
2 - parse the text before importing...
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 19, 2021 at 3:37 pm
My opinion - either can do the install, but the DBA needs to do the configuration. The Server team should be able to handle an install as long as 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.
August 17, 2021 at 2:47 pm
Viewing 15 posts - 961 through 975 (of 2,917 total)