We might even be able to save those 4 extra characters - depending on the source data.  If we know for sure that we have a minimum length of at...

Just one point - not sure it makes a difference in performance but you can avoid this:

@BitBucket = RIGHT('00000000000000'+CONVERT(VARCHAR(14),Col01),14)

By using this:

@BitBucket = RIGHT(CONCAT('00000000000000', Col01),...

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