what is the difference between Delete and Truncate

4 Answers   CarrizalSoft Technologies, Geo Research Centre,

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

What is the recommended total size of your memory optimized tables?

0 Answers  

---

How to replace null values in expressions using isnull()?

0 Answers  

---

Define cross join in sql server joins?

0 Answers  

---

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

Define cursor locking

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,

---

Which are the new data types introduced in sql server 2008?

0 Answers  

---

How you trouble shoot when any job fails

0 Answers  

---