ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What are Sql Reporting Services and  analysis services? Can 
u Explain
 Question Submitted By :: Dinesh Gupta
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are Sql Reporting Services and analysis services? Can u Explain
Answer
# 1
Sql Reporting Services :
-----------------------

Full Reporting Life Cycle Support
SQL Server Reporting Services supports the full reporting 
life cycle, including:

• Report authoring. Report developers can create reports to 
be published to a report server by using Microsoft or other 
design tools that use Report Definition Language (RDL), an 
XML-based industry standard used to define reports. 
 
• Report management. Report definitions, folders, and 
resources are published and managed as a Web service. 
Managed reports can be executed either on demand or on a 
specified schedule, and are cached for consistency and 
performance. New in SQL Server 2005 Reporting Services, 
administrators can use SQL Server Management Studio to 
organize reports and data sources, schedule report 
execution and delivery, and track reporting history. 
 
• Report delivery. SQL Server Reporting Services supports 
both on-demand (pull) and event-based (push) delivery of 
reports. Users can view reports in a Web-based format or in 
e-mail. 
 
• Report security. SQL Server Reporting Services implements 
a flexible, role-based security model to protect reports 
and reporting resources. The product includes extensible 
interfaces for integrating other security models as well.

Analysis Services :
------------------

SQL Server 2005 Analysis Services (SSAS) provides, for the 
first time, a unified and integrated view of all your 
business data as the foundation for all of your traditional 
reporting, online analytical processing (OLAP) analysis, 
Key Performance Indicator (KPI) scorecards, and data mining.
 
Is This Answer Correct ?    5 Yes 0 No
Selvaraj.v
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2 HCL2
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500  2
can you any body tell me the difference between candidate key and primary key  4
How to count the number of duplicate items in a table?  1
What are the magic tables in SQL Server 2000? Infogain5
What is WITH CHECK OPTION Karur-Vysya-Bank-KVB2
What are the types of indexes available with SQL Server?  2
Questions regarding Raiseerror?  1
Display a roll having miminum marks in two subjects? Patni7
What are explicit and implicit transactions?  2
What is a Lock and let me know Different types of locks?  1
What is Covering Indexes? Plz explain with example  2
what are three different authentications to connect linked servers? CitiGroup1
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?  5
What does it mean to have quoted_identifier on? What are the implications of having it off?  2
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh  3
What is Transaction?  2
Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query Wipro3
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.  2
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com