Try our new research platform with insights from 80,000+ expert users

Badges

20 Points
10 Years

User Activity

Over 10 years ago
Try not to use scalar functions in your SQL queries (unless you want your reports to run all day).
Over 10 years ago
You mentioned: I have experience performance degradation at times. Reports run from SQL queries, if they were not optimized when written (coded), then you are going to have performance problems.