Answer Posted / rajender.m

sqlserver:Provides storage, processing and controlled access
of data and rapid transaction processing.

sqlserverAgent:Executes jobs, monitors SQL Server, and fires
alerts, and allows automation of some administrative tasks.

sqlserver analytical services:Supplies online analytical
processing (OLAP) and data mining functionality for business
intelligence

sqlserver browser:Provides SQL Server connection information
to client computers.

sqlserver fulltext search :Quickly creates full-text indexes
on content and properties of structured and semi-structured
data to allow fast linguistic searches on this data.

sqlserver integration services:Provides management support
for SSIS package storage and execution.

sqlserver Reporting services:Manages, executes, renders,
schedules and delivers reports.

sqlserver VSS writer:Provides the interface to
backup/restore Microsoft SQL server through the Windows VSS
infrastructure.

What is xdr?

570

---

Explain primary key?

549

---

can you instantiate a com object by using t-sql? : Sql server database administration

523

---

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

584

---

what is blocking? : Sql server database administration

506

---

---

How to find the list of fixed hard drive and free space on server?

574

---

Explain the architecture of ms sql reporting service?

536

---

What is dynamic cursor in SQL SERVER?

566

---

Using the customer, and order table in northwind database, please write a query to produce xml?

657

---

Why do you need a sql server?

510

---

which table keeps the locking information? : Sql server administration

526

---

Explain the truncate command? : SQL Server Architecture

567

---

What is purpose of normalization?

533

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

647

---

What is mapping schema?

586

---