Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

What are data resources?

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

wht's the differece between sqlserver05 and sqlserver2000

3 Answers  

---

What is an active database?

0 Answers   HCL,

---

How to provide default values to function parameters?

0 Answers  

---

What is SQL server agent?

2 Answers   HCL, SAP Labs,

---

IN Vs OR operator which is best to use sql server.

4 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

How to create Clustered Primary Key to table?

2 Answers  

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---