what method you can use to reduce the overhead of Reporting Services data sources?
Answer / Akhilesh Sharma
To reduce the overhead of Reporting Services (SSRS) data sources, consider using caching, parameterized queries, and shared datasets. Caching can improve performance by storing query results in memory, reducing the need for repeated database queries. Parameterized queries can optimize SQL statements by minimizing dynamic SQL generation. Shared datasets allow you to define a single dataset that can be reused across multiple reports, reducing processing time.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a cache in ssrs?
Can I disable or restrict ssrs export formats (rendering formats)?
What is report snapshot?
What is a dataset and what are the different types of datasets?
What are drilldown reports?
Mention what are the different types of ssrs reports?
How to deploy the Report?
What are the types of ssrs?
Can You Use Data Mining Models In Ssrs?
how you can configure a running aggregate in SSRS?
What is subreport?
When to use null data driven subscription?