DBCC SHRINKFILE doesn't use the database files physical name - it uses either the file_id or the logical name.  Query sys.database_files to get the appropriate file_id or name.

See: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-ver15

Not only is the SELECT slow - but it doesn't return any data to be inserted.  You need to address the issues with that query - which is also accessing...

Take a look at Beyond Compare from Scooter Software.  With that said - comparing HL7 messages isn't going to be easy.  You could easily have duplicates but in different formats...

Using the WinSCP GUI - there is an option to script the connection.  In that option it should provide a script which will show you what that connection is using. ...

I've got to ask, as well.  Why the requirement of doing the transfer with (ugh!) XML?  That is, quite possibly, the absolute slowest and "pipe heavy" method that you...

Removing a database from an AG does not delete or remove the database from SQL Server.  All it does is removes it from the database from the availability group so...

This takes 3 replaces - but gets it done without concatenation:

Select convertedtime = replace(replace(replace(convert(char(19), getdate(), 120), ':', ''), ' ', ''), '-', '')

The problem with all of...

https://docs.microsoft.com/en-us/troubleshoot/windows-server/windows-security/inherited-permissions-not-automatically-update

https://docs.microsoft.com/en-us/troubleshoot/windows-client/windows-security/permissions-on-copying-moving-files

https://serverfault.com/questions/31709/how-to-workaround-the-ntfs-move-copy-design-flaw

Here are just a few articles about this issue.

This is a windows issue - when you 'move' a file from one folder to another the file settings are maintained from the source whereas performing a copy of the...

You don't have a where clause - not sure what the issue is without seeing the full query.  With that said - I have to assume the reason for your...

Not clear what you are asking - but you can change the security at the folder/report level and remove users/groups that shouldn't have access to that folder/report.

You can do a read scale AOAG without the need for a cluster.  You get no HADR features but if it’s just for reporting read scale is ample and...

No - it isn't possible.  You must setup a Windows Server Failover Cluster - and a replica must reside on a different node in the same WSFC (with a few...

Have you tried rebuilding the indexes on the old table - with the same fill factor as the new table?  I would review each index and see what the fill...

Sorry guys another question. What is the benefit to append backups to one file? If I do full backup/diff backup/log backup every day, why I need to append...