Viewing 15 posts - 1,696 through 1,710 (of 2,917 total)
As a thought - can you log into the server as the SSIS Service account? I am thinking about taking the opposite approach as Jeffery Williams (creating a proxy) 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.
July 22, 2020 at 8:37 pm
Another thought - do you NEED columnC in your FinalTable_bedeleted? Probably speed things up a little bit by only pulling the ID's out of FinalTable, no?
Just thinking that 600 million...
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.
July 22, 2020 at 8:19 pm
I am pretty sure that SQL Prompt (at the moment) cannot colorize the tab based on the SQL login (Windows or SQL). That is, if you log in as "sa"...
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.
July 22, 2020 at 5:43 pm
My opinion, no publicly facing messaging system should allow anyone except an account owner to post on their behalf. That is a HUGE privacy concern and could be career ending...
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.
July 22, 2020 at 3:00 pm
First, having the data in a consumable format is something that will get you a LOT more replies. The way you have it now, we have to do the leg-work...
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.
July 22, 2020 at 2:42 pm
My understanding of clustered columnstore indexes is that they are not ordered (except in Azure). So, my opinion, your non-clustered indexes (the UNIQUE and the NONCLUSTERED are both NONCLUSTERED) may...
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.
July 22, 2020 at 2:32 pm
As far as I know, you can't change the color of SSMS based on who you connect as, but you can change the status bar color:
https://www.sqlshack.com/how-to-set-custom-colors-in-the-ssms-status-bar/
And, with a quick test...
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.
July 21, 2020 at 9:30 pm
Oh gotcha... Yep, that makes sense then. You are more curious at the moment which queries may break by changing the index, not which indexes are in use and which...
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.
July 21, 2020 at 8:44 pm
Just putting my 2 cents in here but putting 300 GB of data on a 4 TB disk sounds like overkill. If possible, I'd put it on a SAN 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.
July 21, 2020 at 8:32 pm
I don't see anything obvious (although I am not an XML guru by any means).
Have you thought about looking at the indexes and the data SQL stores on them rather...
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.
July 21, 2020 at 8:10 pm
Since on dev it uses all 56 GB of memory, you would need more than 56 free on live. How much exactly, I am not sure. But you can get...
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.
July 21, 2020 at 7:56 pm
Just to confirm this, you have 1 billion rows in around 5 or 6 tables that are changing frequently where the column needs to be updated?
There are always tricks 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.
July 21, 2020 at 7:13 pm
What "DateDiff" are you trying to get? The number of days, weeks, months, years, hours, seconds, etc?
I suppose the easiest way to help you would be if you could post...
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.
July 21, 2020 at 6:07 pm
I think the faster way to parse XML is to do it outside of SQL. In general, SQL is not "fast" at parsing XML data. I think your interpretation of:
Given...
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.
July 21, 2020 at 5:08 pm
One solution (not mine) was using the Box API:
https://community.box.com/t5/Platform-and-Development-Forum/Using-the-box-api-in-SSIS/td-p/68823
Thank link has the general process as well as some code to help with it.
I personally have not done this as 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.
July 21, 2020 at 4:26 pm
Viewing 15 posts - 1,696 through 1,710 (of 2,917 total)