Clustered Guid Insert Code

GuidTestInsert.ps1

$set = 'abcdefghijklmnopqrstuvwxyz'.ToCharArray()
$rowcount = 2000
$tables = @('GUIDTest','NonGuidTest','SeqGUIDTest')

foreach($table in $tables){
    $Start = Get-Date

    for($row=0;$row -lt $rowcount; $row++){
        $orgname = ''
        for($char=0;$char -lt 20;$char ++){
            $orgname += $set | Get-Random
        }
        Invoke-Sqlcmd -Database dummy -Query "INSERT INTO $table(orgname) VALUES('$orgname');"
    }
    $time = ((Get-Date) - $Start).Seconds

    Write-Host -ForegroundColor Cyan "$table Insert: $rowcount rows, $time seconds"
}