@scdecade - your solution will not work for the OP.  The trim function is not available on SQL Server 2016 and would need to be replaced with a rtrim(ltrim(...)).  It...

I would look at the stats on that table and see if they are up to date.  If they are up to date - then I would look at the...

"Or maybe you've done it once or twice and forgotten about it."

Well, once you've deployed an Availability Group, it's impossible to just forget about about. It's an endless source...

You're right Michael. Seems like someone is trying to put unrelated question. Thanks for suggesting him to to open a new thread.

The question i have is For Node4, which...

You will have to look into the SSRS log files to see if there is any information about those failures.

https://docs.microsoft.com/en-us/sql/reporting-services/report-server/report-server-service-trace-log?view=sql-server-ver15

The TRUNCATE_ONLY option of the backup log command is no longer available.  If that command is executed against a database instance greater than 2008 it will fail with a statement...

The reason why I asked what you're doing the...

You can use DBCC LOGINFO or sys.dm_db_log_info to determine which VLF's are available - as long as that database is not part of an AG.  The Status column...

With that much free space it should be able to shrink some after a transaction log backup.  Unfortunately I don't know a way to determine which VLF in the...

You don't actually need to switch recovery model - unless you cannot perform a transaction log backup due to space issues.  It may take several attempts - but you should...

Very nice collection of algorithms, Jeffrey.  I've got one more for you to add to your collection.

Peter "Peso" Larsson came up with the following basic method quite a while...

I included 3 separate algorithms for calculating Orthodox Easter in the script.  Those algorithms default to providing the Julian date prior to 1783 which is when Britain and her colonies...

It looks to me like you have multiple instances installed on that workstation, and the one you are trying to use is actually installed and utilized as LocalDB.  This is...

It would also help if you have a file specification from whoever is sending this file.  They should be able to tell you what each field represents and the relationship...

I believe you need to restructure the report to produce the single page for a person - and include a parameter to identify that person.  Once you have that report...