You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,

---

What is the difference between char, varchar and nvarchar?

0 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

---

Explain what is lock escalation?

0 Answers  

---

How do you manipulate data?

0 Answers  

---

How do I create a trace in sql server?

0 Answers  

---

Explain system scalar functions?

0 Answers  

---

What is a transact-sql statement?

0 Answers  

---