Consider the following<br /><br />-----------------------------------------------------------------<br />ASSIGNMENT<br />- Index : Integer,...
I know that for best performance should use a firehose cursor if only retrieving data (to fill in a list box, for example). The prblem i have is...
According to a performance tip found on this website, if a recordset is used only to return data, the following is more performant: - CursorType =...
QUERYING -------- I have a big table (1,5 millions of rows, increasing...) with 30 columns, joined with 5 or 6 lookup tables. I have to select only 6...
That's half true: the database will be used by a VB interface but also for reporting. That is, the DB will be accessed daily via the user interface...
quote:Originally posted by Adriaan Okay, last comment from me on this: if you do not split out entities that are in a 1:1 relationship, then you...
This is exactly my same opinion, but people keep on telling me that a surrogate key is better and that sql-server would execute a fast join anyway......
TRANSLATION, TYPING and REPRODUCTION are the only 3 possible subtask, but each of them has different information (plus a number of common...
Consider the following... A JOB describes the processment of a document. Each document can exist in two versions: English and French. A JOB can have...
Consider the following scenario. Table B has an identifying 1:N relationship with table A. Table A ------------------- A_ID (PK) A_Others...
Separate names with a comma.
