InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Can SSRS report Cache results? |
|
Answer» Yes, SSRS allows the cache reports over the reporting server. These cache results enable the users to access the reports FASTER; since the report has been saved in your cache memory. Note: This is one of the most common questions which is asked in the SSRS interview questions for experienced cacndidate. This can also be modernized as per your experience. 6. What would you do to store your query in an SSRS report or a Database server?These can be stored by using the storing PROCEDURE mentioned in the database server. The BENEFIT of storing the query in this way is it stores the data in the compiled format and gives all the advantages of comparing it using Adhoc reports. However, the SQL QUERIES can be stored directly in the text form, though this is not a good practice. |
|