4
Shouts

SQL Server: Why to Avoid TRIM functions in WHERE and JOIN clauses

posted by lionofdezertlionofdezert 778 days, 3 hours, 47 minutes ago
Tuesday, May 03, 2011 4:51:50 PM GMT

Trim functions (LTRIM & RTRIM) are most favorite function of most developers but how negatively effect these functions on query performance, if these are used in WHERE or JOIN clauses. WHY ??

category: Data | clicked: 0 | | source: connectsql.blogspot.com | show counter code

No comments yet, be the first one to post comment.

To post your comment please login or signup