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 9972I 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 8111With 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,
2566Post New Database Management Questions
Explain the role of metadata for the three-layer architecture.
Explain the terms database and dbms. Also, mention the different types of dbms.
What is data modelling techniques?
What are the benefits of database?
What is normalization and why it is used?
Can group by and ordered by used in a single query?
Can we linked SharePoint to a SQL databasebe?
What are the differences between hash join, merge join and nested loops?
How to connect Silverlight application to database?
How to unzip a file in ssis?
What is an entity-relationship model?
What is the purpose of queries in a database?
how to generate an auto incremental number in a ssis package?
Define cursor.
Discuss transparent DBMS?