Viewing 15 posts - 721 through 735 (of 2,917 total)
I am happy to help. I do recommend you look into truth tables. They can be very helpful when working with logic like this. It is VERY easy to think...
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.
December 29, 2021 at 7:03 pm
Just saw your reply there skeleton567 and thought I'd reply too as our process has changed a bit as we changed managers. Now, the process is still that it code...
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.
December 29, 2021 at 5:27 pm
Got an email from Degreed.com giving me recommendations for virtual training and … well, apparently there are urgent SQL courses I need to take today and ...
Well, what do...
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.
December 29, 2021 at 4:50 pm
The difference in how you create them, there is essentially none. If you create a shared data source from the report builder window, it will create the exact same file...
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.
December 28, 2021 at 7:30 pm
I agree with Jeff here - you should be upgrading the SQL instance to something supported. 2012 is out of support. I don't quite see this as going to spam,...
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.
December 28, 2021 at 7:21 pm
If you want to exclude, simply reverse your conditions. For example, rather than "IN" use "NOT IN" or instead of "<" use ">=". Or, alternately, toss some brackets around your...
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.
December 23, 2021 at 7:49 pm
I agree with Scott. And to add to what he said - if you are currently using INT, I would MUCH rather switch to BIGINT before switching to CHAR(50). 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.
December 22, 2021 at 5:42 pm
Where I work, the DBA patches the DBA software (SQL for example) and the IT team patches the OS.
So Windows updates are handled by IT and SQL patches are handled...
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.
December 22, 2021 at 5:30 pm
I am glad I could help. I also want to make a note, which is in my signature, but I want to make it very clear:
As with all advice 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.
December 22, 2021 at 3:22 pm
I have not tested this, but I am 99.99999% confident you could create a temp table (CREATE TABLE #tmpTable(col1 datatype1, col2 datatype2, ...)) with the columns you expect then do...
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.
December 22, 2021 at 3:17 pm
I don't think SQL will be able to rank those the way you wanted them. The reason why - if you are ordering it by "Rating", ID 8 has 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.
December 22, 2021 at 3:14 pm
One thing to keep in mind is if you are using SSIS, you will want the SSMS version that matches the SSIS database version. For example, if you have SSIS...
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.
December 21, 2021 at 2:59 pm
If that error pops up when opening SSMS, I would try doing an uninstall and reinstall. I would also check for free disk space and if you are on 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.
December 20, 2021 at 9:19 pm
We still have Windows XP computers that are "critical" to the company due to similar things. In-house built software that is used for a product we are working to EOL...
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.
December 20, 2021 at 9:14 pm
My HOPE is that your application is throwing an error. Since the application is known, you either have the source to it OR can contact the vendor to get them...
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.
December 20, 2021 at 7:47 pm
Viewing 15 posts - 721 through 735 (of 2,917 total)