I do not have SQL Server running on linux, but I think there may be better tools to report that data than SQL.  Things like Cacti, which is designed for...

I think this depends on what tool you are using to generate the data and what tool you are using to pull it into the database and what data you...

anything in the "users" folder is for a user account.  so those 3 folders are user accounts you have or had on your system at some point.

If I remember right...

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...

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...

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...

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...

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...

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...

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...

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. ...

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...

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...

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? ...

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...