Viewing 15 posts - 1,741 through 1,755 (of 2,917 total)
My guess is you have system restore turned on for that drive.
Setting a limit for VSS likely won't make a difference, but reducing the limit for system restore or turning...
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 13, 2020 at 8:26 pm
Can you provide some sample data where it is not ordered correctly? All of my testing on my system indicates that it should be ordered correctly EXCEPT if you go...
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 13, 2020 at 2:33 pm
Offhand, I am not sure why they can see all of the databases if they only have permissions on the one. A quick check online, it sounds like this isn'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.
July 10, 2020 at 7:16 pm
EDIT - I misunderstood the request. My response was wrong. Deleted.
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 9, 2020 at 5:37 pm
That is odd that it is only system databases that are causing the slowness. My first thought would be to get an estimated execution plan on the system databases 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.
July 9, 2020 at 4:56 pm
This query is close. The only thing it isn't doing QUITE right is the ordering for the Quarters:
USE [Admin];
GO
CREATE TABLE [#temp]
(
[country] VARCHAR(20)
, [ship] VARCHAR(20)
,...
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 9, 2020 at 3:27 pm
Pretty sure that is baked into SSRS. If you want to change it, you'd need to build a custom report wrapper page.
Source:
https://stackoverflow.com/questions/13922932/how-to-set-ssrs-parameter-panel-on-the-top
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 9, 2020 at 3:00 pm
Phil got you most of the way there and your attempts were close.
In the first one, your REPLACE call is missing the values that should be replaced. If you count...
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 8, 2020 at 5:29 pm
Your watch has more features than mine. And mine does have some limitations (screen brightness isn't that bright so it is hard to read on sunny days, is a black...
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 8, 2020 at 3:53 pm
I read that your watch lasts 4-5 days. That's crazy. My smartwatch gets me a month on average.
I think part of the problem is if battery life improves, device manufacturers...
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 8, 2020 at 3:09 pm
SELECT name, SUSER_SNAME(owner_sid)
FROM [sys].databases
That query should do it. Is that what you were looking for?
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 7, 2020 at 9:17 pm
So, to fix your JSON, you need [ ] around the whole thing as it is an array.
Something like this:
SET @SampleJSON = '[
{
"name":...
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 7, 2020 at 8:36 pm
My approach is I want the document to be idiot proof and to cover the exact steps to recover from a disaster.
If I get woke up at 2:00 AM, 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.
July 7, 2020 at 8:11 pm
I have never used the tool azcopy.exe before, but as a thought, does your SQL Server Agent account have permission to the Azure site and have access to the files...
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 7, 2020 at 3:53 pm
My advice is to not do an in-place upgrade. The benefits of an in-place upgrade are that you don't need to change any connection strings in your applications and 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.
July 7, 2020 at 3:00 pm
Viewing 15 posts - 1,741 through 1,755 (of 2,917 total)