Answer Posted / manoj pandey

1. Database: primarily is a collection of Tables that are normalized upto 3-NF and can be interrelated by FKs. It is an OLTP system which is meant for storing data of Information systems, like a CRM, ERP, Company/College/School record management system, and similar Data Entry other tools.

2. Data Warehouse: DW or EDW (Enterprise DW) is a system created by combining more than one Database systems, and/or by getting data from different Sources like heterogeneous Databases, flat-files, data feeds, etc. The tables in this system are de-normalized like in 1-NF, so that all related information is in a single table. Is is an OLAP system which is meant mainly for Reporting.

3. Data Mart: are built on top of a Data Warehouse, either by creating Views from underlying tables or a CUBE from fact & dimension tables.

~Manoj (http://sqlwithmanoj.wordpress.com)

Explain what is it unwise to create wide clustered index keys?

929

---

Define Wed Edition in SQL Azure?

100

---

What are system databases into sql server (2005/2008) : sql server database administration

964

---

Suggest a method of joining two tables.

1101

---

How to delete all rows with truncate table statement in ms sql server?

929

---

What is difference between sql and sql server?

937

---

What is ddl command?

926

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1010

---

What is the use of custom fields in report?

945

---

What is the beast way to write CTE in SQL Server ?

981

---

How to create new tables with "create table" statements in ms sql server?

997

---

Do you know what is normalization of database? What are its benefits?

1028

---

What is the difference between set and select?

1015

---

Do you have any idea about the tcl commands?

909

---

Explain the flow of creating a cube? : sql server analysis services, ssas

1002

---