Badges
20 Points
10 Years
User Activity
Almost 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).
Almost 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
Almost 11 years ago
BI (Business Intelligence) Tools
Almost 11 years ago
BI (Business Intelligence) Tools