Answer / Karan Kumar

To drop an existing user-defined function (UDF) in MS SQL Server, use the DROP FUNCTION statement:nn`DROP FUNCTION [schema_name].function_name;`

What is set nocount on and what is set nocount off?

1 Answers  

---

Explain transaction isolation levels in sql server?

1 Answers  

---

Is null in sql server?

1 Answers  

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

1 Answers  

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

What are different types of raid levels?

1 Answers  

---

What does executeupdate return?

1 Answers  

---

What do you mean by a Composite primary key?

1 Answers   Genpact,

---

What is a self join in sql server?

1 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

What is the default sql server instance name?

1 Answers  

---

Explain the difference between clustered and non-clustered index?

1 Answers  

---