I did give a try to ChatGPT about explaining SQL Code. Guthub Copilot is probably based on ChatGPT but more optimized at dealing with coding problems.

It can explain the basis...

About previous error, I changed the extension of the file and I'm trying to upload it again.

Hi Konstantin,

I'm not very familiar with pull request process in GitHub.

I want to submit a modification to readme.md page of sqlserver-kit/Utilities/README.md to add a decent explanation of what YourSqlDba is...

Update (SQL2016-SQL2017) about CROSS APPLY and optimization:

CROSS APPLY aren't necessarily optimized with nested loop.

The optimizer now optimizes them like any joins if possible.

CROSS APPLY is the best tool created ever...

You have to take into account, that this is the SQL Server database engine service account that must have the right to access this share.  
The account under which...

YourSqlDba: There is a free maintenance tool that is described in the readme portion of this page at his adress.  https://github.com/pelsql/YourSqlDba

It covers the five basic maintenance...

This approach needs some more improvements. Updating all columns is problematic for trigger that test "if update()" because if there is no necessarily a real change. You put the...

I use the following strategy : At full backup time, two new file name are generated (including a timestamp in the name): one for full backups, one for log...

Be careful how you grant your permissions, there is share permissions, and there is ntfs permissions. I got this problem some day because I forgot share permissions.

Found why....

By checking more how index are created by my developers, if found that one method for index creation is setting page level locking...

The problem is that I have also this porblem that appears spuriously from differents index on my development box.

I suspect a bug in the...

Oups.. "as if the row hold more than 8096 bytes"

You should specify that varchar(max) and nvarchar(max) are new features specific only to SQL2005 and that they make appears as if the row hold more that 8096 rows.

Varchar(max) and nvarchar(max)...

Hi,

Just try to do all this in one single batch.  All theses statements can be put together in one single execute like this.

strSQL = "IF EXISTS (SELECT * FROM sysobjects...