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 9979I 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 8112With 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,
2567Post New Database Management Questions
Is it possible to declare or create a cursor for update of table? If no tell me why?
What is the default '-sort' order for a sql?
What do you mean by Correlated subquery in database?
What is normalization and why it is used?
Explain the components of rdbms?
What are the components of rdbms?
How to unzip a file in ssis?
What is the difference between multiload and fastload interms of performance?
What are database functions?
How to prevent concurrent access to my data?
Describe a subquery.
how to solve cardinality in dbms...many to many ralationships
What are the limitations of rdbms?
Which is the best free database software?
What is a field in database?