The radicand is floating point so the result will also be.  Rounding the floating point result will remain floating point.

Agreed the indexing logic isn't right.  Negative values index backwards from the end of the string (-1 being the last character, etc.)  In this case, the index of 0 and...

From the horse's mouth...

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/determining-effective-database-engine-permissions?view=sql-server-ver15

• This reply was modified 3 years, 10 months ago by  Steve Jones - SSC Editor. Reason: remove script

Regarding: I saw a note from Brent Ozar that the GitLab job description for a database specialist doesn't mention backups. It does say a solid understanding of the parts of the database,...