Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

What are the different types of Indexes available in SQL Server?

0 Answers  

---

How you can change the database name in SQL SERVER?

0 Answers  

---

Where is localdb stored?

0 Answers  

---

What is a hint?

0 Answers  

---

Does full backup break log chain?

0 Answers  

---

What are the different types of normalization?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

From where can you change the default port?

3 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---