Explain the architecture of ms sql reporting service?
Answer / Bhupendra Pratap Singh
The architecture of MS SQL Reporting Services consists of the Report Server, the Report Manager (web-based interface), and the Report Builder (for creating reports). The Report Server manages report processing, delivery, and security.
| Is This Answer Correct ? | 0 Yes | 0 No |
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
Explain concepts of analysis services?
Explain Capacity planning to create a database? and how to monitor it?
What are the advantages of user-defined functions over stored procedures in sql server?
What is normalization of database?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What value could be assigned to Varchar Type?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
how can i view structure of table in sql server? tell me that query.
What are different types of data sources?
How m-m relationships are implemented?
What is local temp table?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)