Answer / Alok Yadav

The First Normal Form (1NF) is a database normalization rule that ensures each column in a table contains atomic or indivisible values, and that each table has a primary key. In 1NF, there should be no repeating groups, no arrays within columns, and all columns should contain unique values.

What command would you use to add a column to a table in sql server?

1 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

How to create a simple user defined function in ms sql server?

1 Answers  

---

what is index seek and index scan?

2 Answers  

---

What is the size of transaction log file?

1 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

How do you drop an index?

1 Answers  

---

What stored by the model? : sql server database administration

1 Answers  

---

What is indexed views? plz explain with example?

2 Answers  

---

Explain the collation?

1 Answers  

---

how many instance use in sql server 2005

4 Answers   EFI, HCL,

---

What is the difference between varchar and nvarchar datatypes?

1 Answers  

---