it_user115422

Works at a tech company with 51-200 employees

Badges

20 Points12 Years

User Activity

Almost 12 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 12 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.

Experience

Comments

Almost 12 years ago

BI (Business Intelligence) Tools

We evaluated both SSRS and Business Objects. We chose SSRS and currently use Cognos as well.

Almost 12 years ago

BI (Business Intelligence) Tools

We evaluated both SSRS and Business Objects. We chose SSRS and currently use Cognos as well.