Viewing 15 posts - 1,546 through 1,560 (of 2,917 total)
Something to note - if you don't have a visual studio subscription, I am pretty sure that SSRS is going to require a license to use, as will 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.
September 18, 2020 at 5:58 pm
Is there a reason you aren't installing SQL Server 2019 as the instance for SSRS 2019?
But as for compatability, I can't see why it wouldn't work. What error are 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.
September 18, 2020 at 3:14 pm
My approach to this - what changed since this was working 100% of the time? If this was always working until you installed CU21, then it is likely a bug...
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.
September 18, 2020 at 3:08 pm
I like option 3 of blank. And the fact some people picked that.
But this is a good one to know if you don't have a Git GUI.
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.
September 18, 2020 at 2:54 pm
Heh, I wouldn't say I am "smarter", I would say "I got lucky". I took mrsiro's approach and just expanded on it. A bad (or possibly good?) habit of mine...
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.
September 18, 2020 at 2:47 pm
I half agree with Jeff there. Python may not be the best option for all use cases but, like cursors, there are cases where it is the best or only...
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.
September 18, 2020 at 2:36 pm
My opinion - I don't think there are that many use cases for using it. Similar to R - you can access it externally, does it need to be baked...
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.
September 17, 2020 at 8:47 pm
Possibly not the most efficient approach, but I think this should work:
SELECT
[job3].[TheDate]
, REPLACE( [job3].[Security]
, 'REMOVE:'
, ''
) AS [Security]
, REPLACE( [job3].[Driver]
, 'REMOVE:'
, ''
...
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.
September 17, 2020 at 8:40 pm
Are you updating the tables sequentially or are some being done at the same time?
That being said, how many rows are being updated in tbl_people? If on 2020-08-07 it updated...
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.
September 17, 2020 at 7:41 pm
My opinion - I would use it when I need to do analytics on the data; similar to when you'd use R.
My approach though is to use these tools outside...
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.
September 17, 2020 at 7:30 pm
Alternately to Sue's approach, try matching your SSMS version to your SQL Server engine version. I know some things behave strangely when you have mismatched versions.
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.
September 17, 2020 at 6:04 pm
It could be the disks. It could be the data. It could be the CPU or memory. It could be blocking. It could be none of those. It could 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.
September 17, 2020 at 2:11 pm
I think this script will do it:
USE [msdb];
GO
SELECT
[name]
, [step_id]
, [step_name]
, [message]
, [run_status]
, [run_date]
, [run_time]
, [run_duration]
FROM[dbo].[sysjobhistory]
JOIN[dbo].[sysjobs]
ON [sysjobs].[job_id] = [sysjobhistory].[job_id]
WHERE[step_id] > 0;
Just add an extra...
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.
September 16, 2020 at 7:35 pm
My advice - check the dump. Chances are it was not a specific query that caused the dump but something else. Could be a driver issue, could be hardware failure,...
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.
September 16, 2020 at 7:05 pm
The issue is that NULL is an unknown value. @x=NULL and NOT(@x=NULL) both give a result of FALSE. Technically, they give NULL which gets evaluated to FALSE in a CASE...
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.
September 16, 2020 at 5:54 pm
Viewing 15 posts - 1,546 through 1,560 (of 2,917 total)