Would you store your query in a ssrs report or a database server? State the reason why?
Answer / Narendra Singh Rajput
Storing queries in a database server is preferred over a SSRS report because it reduces redundancy, improves performance (since queries are executed on the database server), and ensures data consistency. In SSRS reports, queries are typically embedded for convenience, but this approach should be used with caution to avoid potential issues.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to backup SQL Server Reporting Services ?
What is query parameter in ssrs?
How can I add Reporting Services reports to my application?
What is the chart in report?
What is report snapshot?
what are the important architecture components of SSRS?
What are cascading parameters in ssrs reports?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
how you can deploy an ssrs report?
Explain how you can deploy an SSRS report?
What are the new features are introduced in sql server 2012 reporting services?
What are the export options of ssrs?