Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?
eBay,
3 10029I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?
1 8122With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
eBay,
2577Post New Database Management Questions
What are the limitations of database?
What are the differences between drop, truncate and delete commands?
Explain data independence?
Can you explain the select into statement?
Why indexing is used in database?
When would you use a database?
What is correlated subquery in dbms?
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
Why is database used?
How big is google's database?
What do you mean by entity type extension?
Define join types.
What are the limitations of using a model?
What are the features of rdbms?
Explain types of indexing in dbms?