Viewing 15 posts - 2,281 through 2,295 (of 2,917 total)
Yeah, I would agree with that.
My knowledge of the IT world comes because I worked in IT prior to moving to being a software developer (mostly web based) 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.
October 20, 2017 at 2:24 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.
October 20, 2017 at 11:44 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.
October 20, 2017 at 11:25 am
Did you reboot the server after installing CU5?
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 20, 2017 at 11:21 am
That is a lot to bite off. If you want basic IT, I'd recommend looking at getting your A+ certification. If you want to specialize in servers, then I 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.
October 20, 2017 at 11:17 am
One will return all of the columns and data from table1, the other will return nothing and just store the value 1 in the variable @num (presuming at least 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 20, 2017 at 10:55 am
My opinion is that it depends. Some tasks are good to do in a stored procedure or function, while others are better to do in your code. It is 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.
October 19, 2017 at 3:14 pm
I could be wrong, but I am fairly certain that the data would hit server C.
Server C would be doing all of the data transforms which SSIS is usually...
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 19, 2017 at 10:59 am
You can. That is actually how we have things running where I work. I have SQL 2008 R2, 2012 and 2016 all running on the same box.
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 18, 2017 at 2:15 pm
This may not be the most efficient method, but could you implement something like this:DECLARE @date DATE = '2017-04-17';
SELECT
CASE WHEN DATEPART(MONTH, @date) = DATEPART(MONTH,...
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 17, 2017 at 10:51 am
Instead of running "sp_addrolemember", try running
sp_addsrvrolemember <AD account>,'sysadmin'
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, 2017 at 2:22 pm
Am trying to create maintenance plans like backups using ssms in SQL Server...
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, 2017 at 11:18 am
I think your best bet is to follow something like this:
https://stackoverflow.com/questions/38995380/sql-server-how-to-attach-repair-a-detached-damaged-database
In the answer, steps 1 through 4 will get the database online but you will be...
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 11, 2017 at 4:30 pm
I like a home made pizza with honey garlic sauce instead of tomato based, chicken, onoin, pineapple and tons of cheese added afterwards.
Family Pizza inspired that one for me...
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 11, 2017 at 4:23 pm
Sorry, I skimmed over the MDS part of that. My bad.
Have you looked at the MSDN articles on MDS's (https://docs.microsoft.com/en-us/sql/master-data-services/overview-importing-data-from-tables-master-data-services)? That should help lead you in the right...
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 11, 2017 at 11:03 am
Viewing 15 posts - 2,281 through 2,295 (of 2,917 total)