Monthly Archives: June 2011

Toggling is not working in the Report

Posted on June 27, 2011 by randheerparmar

If a report is not generating any error but still the toggling is not working properly i.e. the expansion is not happening on + button click then there could be one main reason that this error might be coming because … Continue reading →

Posted in SSRS Interview Questions | 2 Comments

Consolidated Questions

Posted on June 16, 2011 by randheerparmar

I am posting the questions and answers one by one irrespective of topics so i can give more detailed answers for questions.To view consolidated questions topic wise you can go and click the content in side bar and check all questions … Continue reading →

Posted in SSRS Interview Questions | Leave a comment

What are the different schemas available for Data warehouse?

Posted on June 14, 2011 by randheerparmar

Data warehouse can be created two types of schema 1) Snowflake 2) Star Schema. The mostly star schema is used to create a data warehouse as fact is the centre table and it’s surrounded by different dimensions. I.e. many dimensions … Continue reading →

Posted in SSAS Interview questions | Leave a comment

What is Data warehouse?

Posted on June 14, 2011 by randheerparmar

Data warehouse is the collection of data which could be the collection of many or single transaction data source. Data warehouse is the used for creating the reports for senior management. Then the question comes how come it happens.  Data … Continue reading →

Posted in SSAS Interview questions | Leave a comment

What are the maintenance Tasks in SSIS ?

Posted on June 14, 2011 by randheerparmar

Maintenance Tasks are the task which can be used to maintain database administration activities. IT contains the task which performs the SQL Server agent tasks. SSIS contains the task for backup, restore and job executions functionality of SQL server management … Continue reading →

Posted in SSIS Interview Questions and Answers | Leave a comment

What is ADHOC Report in SSRS?

Posted on June 13, 2011 by randheerparmar

Adhoc Reports (In SQL Server Reporting Services) are the reports which user can create using report model project (User here refers to end user who is using the application). These reports have a predefined layout which is a standard layout … Continue reading →

Posted in SSRS Interview Questions | Leave a comment

Why can’t we use page total in the report body?

Posted on June 13, 2011 by randheerparmar

The built in field [&pagenumber] and [&pagetotal] cannot be used in report body as these are applicable in report header or report footer. These built in field can be added in footer or header for better representation of the report.

Posted in SSRS Interview Questions | Leave a comment

What is normalization in SQL Server Database?

Posted on June 10, 2011 by randheerparmar

Normalization means to separate the data in multiple related tables using formal methods. I.e. its major objective is to divide larger tables in to smaller table to reduce data redundancy and improve perfor4mance of the data base. 1.           Some basic … Continue reading →

Posted in SQL Server Interview Questions and Answers | Leave a comment