Viewing 15 posts - 1,636 through 1,650 (of 2,917 total)
Something to note - adding all of the recommended indexes isn't always going to be great for performance.
On a highly OLAP environment, automatic index tuning doesn't sound too bad. On...
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 6, 2020 at 5:06 pm
Hopefully it isn't corruption, but if it isn't, then I'd be checking other things like the antivirus to make sure it is not scanning the database files.
Might not hurt (if...
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 6, 2020 at 2:08 pm
Nice. It does sound like a useful tool for sure.
If I was connecting to a business critical server, I'd want to do some analytics on the tool to make sure...
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 5, 2020 at 9:51 pm
Mike01, I think what Michael L John is looking for is what filters to put in place to strip out some of that "junk" data.
A quick look at what he...
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 5, 2020 at 7:33 pm
My opinion on this is that it falls into the "it depends" bucket that most database tasks do.
I personally like having the point in time source of truth available in...
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 5, 2020 at 5:25 pm
I personally have not used it. How does it handle windows authentication or does it only work with SQL authentication?
As a general rule, I try not to run any app...
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 5, 2020 at 4:47 pm
Quick google - it depends on if it is ReFS or NTFS. If ReFS, it should be doing self-healing. I expect this is true until the disks start failing. On...
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 5, 2020 at 2:23 pm
First thing I'd do is chkdsk on the physical disk to rule out disk corruption.
But it sounds to me like some disk based error and likely not a database error. ...
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 4, 2020 at 8:19 pm
Also, another thought here, since the FULL backups are succeeding without a problem, maybe check the syntax on those vs the syntax on your tlog backups?
I still like having scripts...
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 4, 2020 at 4:53 pm
My preference with code comments is all code functions (stored procedures, triggers, tables, views, etc on the SQL side, methods, classes and functions on the .NET side) should have 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 4, 2020 at 4:45 pm
You want this to be 0 seconds... a fun challenge, but may not be possible.
How often does this data change? Are you OK with "snapshot" data rather than realtime data? ...
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 4, 2020 at 4:26 pm
ScottPletcher is right - LEAD and LAG were introduced in 2012. I am bad at this recently. I thought they were a 2016 and newer feature. Good to know!
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.
August 4, 2020 at 4:04 pm
Yeah, for something like backups, I like having short and easy to test/debug scripts rather than "all in one" scripts like Ola's. That is just my preference, especially since Ola's...
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 31, 2020 at 9:49 pm
A work around - use shorter filenames for your backups.
I personally don't use Ola's scripts just for the reason you found - if a bug crops up, I either need...
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 31, 2020 at 9:29 pm
How does this look:
CREATE TABLE [#filetable]
(
[FileID] VARCHAR(20)
, [GroupID] VARCHAR(10)
, [Level] VARCHAR(1)
, [Path] VARCHAR(255)
, [Filename] VARCHAR(255)
, [ExpectingResultofPath] VARCHAR(MAX)
);
INSERT INTO [#filetable]
(
[FileID]
, [GroupID]
, [Level]
, [Path]
,...
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 31, 2020 at 9:18 pm
Viewing 15 posts - 1,636 through 1,650 (of 2,917 total)