Viewing 15 posts - 901 through 915 (of 2,917 total)
An alternate, but similar, approach would be to add a sequential integer column to the table rather than the row_number approach. This should have better SELECT performance than row_number() at...
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 12, 2021 at 8:35 pm
What I am seeing is it failed validation. If I remember right, failed validation is thrown when metadata changed. So you will need to edit the SSIS package to update...
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 12, 2021 at 7:55 pm
Grow TEMPDB is another step where possible. I try to ensure I have enough disk space to allow for autogrowth and I try to monitor for abnormal autogrowth on all...
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 12, 2021 at 7:50 pm
For the database itself, our naming convention is to either name it after the application that uses it, or if multiple applications are using it, then the processes that 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, 2021 at 9:33 pm
"best" standards really depend on your environment and how often objects will change and how your team works.
For example, I like naming my tables with the name of the entity...
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, 2021 at 9:05 pm
My approach would be to get this working in TSQL then put the TSQL into SSIS as your source.
My approach (likely not the most efficient) would be to do 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.
October 8, 2021 at 8:48 pm
Alternately, you could use windowing functions to sum the decals column like:
SUM(decals) OVER (PARTITION BY a.FSTRJURISDICTION, d.fstrFormattedID, inv.flngNumItems, ar.fstrStreet, lic.fstrStatus, a.fstrFuelType)
Not ideal as you will get 1...
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, 2021 at 8:35 pm
I do not know a lot about Azure data factory, but looking at the screenshots, it LOOKS to me like you are only pulling 1 column from ParquetSource. 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.
October 8, 2021 at 5:44 pm
One other thing to look at would be bandwidth. On-Prem, you may have a Gb ethernet connection between you and the server. In the cloud, you may have reduced bandwidth.
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 7, 2021 at 2:37 pm
First, welcome to the SQL Server forum... next, you posted this in the wrong section. You are not running SQL Server 2019, you are running MariaDB.
I would recommend looking up...
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, 2021 at 2:25 pm
I think the easiest way to fix a "log file full" is to increase the size of the log file, but that assumes you have disk to do so.
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.
October 6, 2021 at 8:57 pm
To add to everyone else asking about the code, are you sure it is the function that "crashed the ETL - it now never finishes."? I am wondering if MAYBE...
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 6, 2021 at 8:50 pm
I've not worked with JSON in SQL before, but my first debugging step would be to do a SELECT @json to make sure that you got the full data 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.
October 5, 2021 at 10:17 pm
The other thing to keep in mind is do you have anything else running on that server? From a SQL Server standpoint, SSIS, SSAS, and SSRS all use their own...
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 5, 2021 at 4:08 pm
If you don't need the end user connecting as themselves, you could have it connect as a specific user on the remote machine. Downside is you may need to create...
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 5, 2021 at 3:58 pm
Viewing 15 posts - 901 through 915 (of 2,917 total)