Can PD help me identify all the joins between varchar/char fields and nvarchar/nchar fields?

[bog]

Hello,

If I do a full reverse engineering of a SQL Server 2008r2 database, can I write a report that allows me to find all ***CHAR fields that appear in joins against fields with a different N***CHAR field?

Our database does not use consistently either nvarchar/nchar or varchar/char for text fields and we came across performance issues due to joins between varchar and nvarchar fields.

Is there a way in PD to identify joins between such fields that occur in views and stored procedures in a form of report? I know it is a hard problem that would require the parsing of views and stored procedures code.

Thanks

[Ondrej_Divis]

As George proposed, you can create List Report (based on Reference Joins) and simple computed extended attribute (JoinDisproportion in my example), which will do the checking for you and will keep only inconsistent joins in the report.

HTH,

Ondrej