Answer / uma lakshman

Quickest method to load large data into a table is to
use "BCP"(bulk copy).

Answer / rajendra prasad reddy penumall

YESit is possibl by using TEXT data type.
It cn handle data upto 2GB

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

How can you check the version of sql server?

0 Answers  

---

How secure is sql server database?

0 Answers  

---

Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,

---

---

how to rest identity columns in sql server

3 Answers   Matrix,

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

Difference between aggregate functions of sql?

0 Answers   EXL,

---

What is the use of stored procedure?

0 Answers  

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

What is the New in SQL server 2008?

0 Answers  

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---