how many layers of tcp/ip protocol combined of? : Sql server database administration

0 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

List out the different types of locks available in sql server?

0 Answers  

---

where do you use Isolations?give me some exmpale?

1 Answers  

---

what type of indexes physically sort data?

3 Answers  

---

How to generate create table script on an existing table in ms sql server?

0 Answers  

---

Differentiate between a primary key and a unique key.

0 Answers  

---

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

What is normalization in Database ?

4 Answers  

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---