Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what method you can use to reduce the overhead of Reporting Services data sources?



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

Post New Answer

More SSRS SQL Server Reporting Services Interview Questions

how would you store your query in an SSRS report or a Database server?

1 Answers  


what are the important architecture components of SSRS?

1 Answers  


What are click through reports?

1 Answers  


What are sub reports and how to create them?

1 Answers  


What is the rdl file?

1 Answers  


What are cascading parameters in ssrs reports?

1 Answers  


Explain how you can configure a running aggregate in SSRS?

1 Answers  


Describe different Processing Modes offered by SSRS?

1 Answers  


what are the different types of SSRS reports?

1 Answers  


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

1 Answers  


What are drillthrough reports?

1 Answers  


What are the new features of sql server 2012 reporting service?

1 Answers  


Categories
  • SSRS SQL Server Reporting Services Interview Questions SSRS SQL Server Reporting Services (140)
  • Microsoft Azure SQL Interview Questions Microsoft Azure SQL (73)