Signs and symptoms of trigger finger may progress from mild to severe and include: 1  Finger stiffness, particularly in the morning.
I was asked this question the other week and had a look in the documentation for 8.1.7 (the database is still stuck on this version at the app vendor's insistence) This is what it says there :- SQL Statement Length Maximum length of statements 64K maximum; particular tools may impose lower limits..
According to your description, you want to know the max length of a PowerShell string variable. Strings in PowerShell (and most of the other programming languages) are of Fixed length or immutable (they cannot change). .net also offers a mutable string object System.Text.StringBuilder, which should be your preference if you change the string a lot through out its lifetime.