Badges
20 Points
11 Years
User Activity
About 11 years ago
Commented on We evaluated both SSRS and Business Objects. We chose SSRS and currently use Cognos as well.
Try not to use scalar functions in your SQL queries (unless you want your reports to run all day).
About 11 years ago
Commented on We evaluated both SSRS and Business Objects. We chose SSRS and currently use Cognos as well.
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.
Comments
About 11 years ago
BI (Business Intelligence) Tools
About 11 years ago
BI (Business Intelligence) Tools