Viewing 15 posts - 2,476 through 2,490 (of 2,917 total)
Another thing you could do is have a calculation table. Presuming that there is some correlation between size and quantity in some cases.
That way if you have some correlation...
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 3, 2017 at 9:04 am
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 3, 2017 at 8:37 am
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 3, 2017 at 8:30 am
Not sure this suits your needs or not, but what about selecting it into a table like this:declare @linkedserverName varchar(100) = 'servername'
declare @DB_rename varchar(100) = 'DBName'
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.
June 29, 2017 at 4:26 pm
I got tasked with a similar thing recently and something else to watch for is user that is created without login or user that is created with a login of...
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.
June 29, 2017 at 3:51 pm
Just so I understand correctly, you have a comma separated list in a flat file and you want to select out of it?
If this is correct, you would want...
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.
June 29, 2017 at 3:41 pm
Yep, that makes a bit of sense.
As for the section:
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.
June 29, 2017 at 2:45 pm
I got this one:SELECT CASE WHEN [CYsales].[cust_id] IS NULL THEN [LYsales].[cust_id] ELSE [CYsales].[cust_id] END AS [cust_ID]
, [CYsales].[sales]
, [LYsales].[sales]
FROM [CYsales]
FULL OUTER JOIN [LYsales] ON...
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.
June 29, 2017 at 2:33 pm
I am just curuios why would you want to break that up into 2 statements instead of 1?
I know you can, I'm just not sure what the benefit 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.
June 29, 2017 at 2:29 pm
Could do it outside SSIS as well (if that is an option).
If it is required to do it from SSIS, I think either looping, or if you have xp_cmdshell...
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.
June 29, 2017 at 1:57 pm
2 thoughts:
1 - are you on the latest SP/CU?
2 - I think this error might have a bit more to it:
Errors were encountered in the procedure 'dbo.apspuRackUpNextUsed'...
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.
June 29, 2017 at 12:36 pm
Not meaning to bring back a dead post, but kind of curious what happened with this?
OP - did you get more memory in the system?
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.
June 29, 2017 at 12:21 pm
I could be dumb, but when I look at your calculation and your input flat file, I think you are over-working the date are you not?
the date 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.
June 28, 2017 at 4:16 pm
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.
June 28, 2017 at 2:36 pm
This is for log shipping, correct?
If so, did you see this post:
https://www.sqlservercentral.com/Forums/1103972/extremely-slow-log-shipping-restore-in-standby-mode?PageIndex=2
The "best" solution that I see from there was 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.
June 28, 2017 at 2:32 pm
Viewing 15 posts - 2,476 through 2,490 (of 2,917 total)