Will you use an SSRS Report or a database server to store your query? – InterviewSolution

InterviewSolution

1.	Will you use an SSRS Report or a database server to store your query? Why do you think that is?
Answer» The SQL queries should be saved in a database SERVER's stored procedure. Because storing SQL queries in text FORMAT is no longer regarded as good practice, it should be avoided. SQL would be in an accumulating format if queries were stored in Store Procedures to a DATA server, while still GIVING all of the benefits of USING a Stored Procedure.

Discussion

No Comment Found

Related InterviewSolutions

Mention some of the different servers with which you can use SQL Server Reporting Services (SSRS).
Mention some of the open source softwares which are an alternative to SQL Server Reporting Services (SSRS).
Mention a technique for lowering the overhead of Reporting Services data sources.
Explain what you mean by multi-value parameter in an SSRS report.
Will you use an SSRS Report or a database server to store your query? Why do you think that is?
In an SSRS Report, how would you generate a Sequence Number for all of the records?
When generating a Radio Button Parameter Type in a SQL Server Reporting Services Report, what data type should be used?
What do you understand about pagination in SQL Server Reporting Services (SSRS)?
Mention some of the rendering extensions available in SQL Server Reporting Services (SSRS).
Explain the different types of reports in the context of SQL Server Reporting Services (SSRS).