Viewing 15 posts - 2,356 through 2,370 (of 2,917 total)
Geeze, I seem to be bad at offering advice today, eh?
I apologize for the misinformation I provided.
That being said, and back to the OP, I don't...
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 21, 2017 at 10:42 am
Right... forgot that developer only went free with future versions.
With express, does that let you do SSIS? I can't remember and it has been a very long time...
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 21, 2017 at 9:10 am
I think that you need to use Visual Studio 2008 (with the SQL Server Data Tools installed) and that should allow you to create SSIS pacakges to run against a...
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 21, 2017 at 8:33 am
Pretty sure Express doesn't include the advanced things like SSIS. It should be part of the install (Integration Services). I actually thought that SQL Server Agent didn't work with express...
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 18, 2017 at 3:25 pm
Not sure if I'm helping or not, but I know where I work, we have a separate job for cleaning up the history. My preference is to have a maintenance...
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, 2017 at 10:25 am
OH... you could likely sum it over a partition then, no? The above is all just my opinion on what you should do.
It is the t.MktDiff column that you are trying to sum up... what if you change the line:
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 16, 2017 at 11:20 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.
August 16, 2017 at 9:21 am
After it is...
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 16, 2017 at 8:34 am
Do all of your parameters need to be unique? That is, is could you reduce the number of parameters by reusing some?
If not, could update the parameters 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.
August 15, 2017 at 4:24 pm
Can you post DDL and sample data for TRValue and TRProp?
We'll need more info in order to help. But best guess is that it isn't actually skipping it, 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.
August 15, 2017 at 4:18 pm
I'm sure there are some free tools, but I recommend RedGate's SQL Compare for that task.
I used it when we were upgrading a system recently and found 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.
August 15, 2017 at 11:12 am
My personal preference is to not fill the disk. Start the database out at a reasonable size.
Filling the disk means you may get a surprise one day when 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.
August 14, 2017 at 4:41 pm
I think (but can't be sure without seeing the data) is that you'd want to add an extra clause to your WHERE in the nested selects. You would want to...
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 14, 2017 at 4:15 pm
To me, your solution sounds more like a workaround to me. Or did running that once fix the log growth issue?
I'm just thinking that to me, your solution...
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 14, 2017 at 10:58 am
Depending on how they need to share the data, you could have a new database per city.
likely not an ideal solution, but it is another option.
a new...
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 8, 2017 at 3:46 pm
Viewing 15 posts - 2,356 through 2,370 (of 2,917 total)