How do you load large data to the SQL server database?
Answers were Sorted based on User's Feedback
Answer / uma lakshman
Quickest method to load large data into a table is to
use "BCP"(bulk copy).
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / rajendra prasad reddy penumall
YESit is possibl by using TEXT data type.
It cn handle data upto 2GB
| Is This Answer Correct ? | 4 Yes | 0 No |
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Tell me what is difference between clustered and non clustered index?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
How to find the second highest salary of an employee?
How you can change a cross join into an inner join?
Give a example to search fr a string in all stored procedure in sql server.
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is the purpose of indexing?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Explain what is “asynchronous” communication in sql server service broker?
If a stored procedure is taking a table data type, how it looks?
what is database replicaion? : Sql server database administration
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)