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?
3 8677I 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 7264With 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?
2061Given an array of size N in which every number is between 1 and N, determine if there are any duplicates in it. You are allowed to destroy the array if you like.
21 46027Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
3 10980A big cube painted with yellow colour in all sides. if you cut it into 1000 cubes with same dimension. than how many cubes were without painted anyside. explain it?
12 39673Post New eBay Interview Questions
How to create index after every query insert?
How to call a non virtual function in the derived class by using base class pointer
What is aspect-oriented programming?
Define nusselt number [nu].
How can you load large amounts of data from flat-text files?
How do you determine whether to use a stream function or a low-level function?
What are the default settings of left and right margins?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What are the types of macro formats?
How can the OUT OF MEMORY be solved?
How transaction management works in Hibernate?
What is the database trigger?
what is a composite key ? : Sql dba
How do I compare two columns in excel with conditional formatting?
How many gb is an operating system?