Opinionated Software

… we have opinions about everything!

Archive for the ‘SQL Server’ Category

PeopleTools and Parallelism on SQL Server —

During a recent discussion with another PS Admin running on SQL Server it became apparent that his efforts to improve application SQL performance through adding more CPUs (with the associated license costs) were based on a fundamentally wrong assumption: PeopleTools/Application SQL will go parallel if needed. This is simply not true. In fact, most SELECT […]

PeopleTools Indexing on SQL Server —

PeopleTools was designed to be database agnostic. In the past, the database support included databases such as Gupta SQLBase, Allbase, Informix and Sybase. The ability to support multiple platforms and add others relatively easily was a consequence of some excellent initial design decisions. Sadly, database platform support has dwindled to Oracle, SQL Server and DB2 […]

PSTREENODE Clustered Index Change —

I noticed that in PT 8.55 (well at least in .08 and later) that the PeopleTools meta-data for the Clustered Index on PSTREENODE lost the “clustered” attribute. I’m not sure why this was changed but you should be aware that this change could impact your execution plans – especially if you use row level security. […]

Opening UTF-16LE files in Perl —

Placeholder for useful code snippet: open my $fh, ‘<:raw:perlio:encoding(UTF-16LE):crlf’, $filenameopen my $fh, ‘<:raw:perlio:encoding(UTF-16LE):crlf’, $filename which will convert CR/LF combinations to LF only. Alternatively, to keep them intact: open my $fh, ‘<:raw:perlio:encoding(UTF-16LE)’, $filenameopen my $fh, ‘<:raw:perlio:encoding(UTF-16LE)’, $filename Useful for reading Windows registry export files, SQL server log export files etc.