Search Results

INDEX NEWBIE: help requested

Thread by: TheGios, Mar 2, 2005, 2 replies, in forum: Performance Tuning for DBAs

Consider the following<br /><br />-----------------------------------------------------------------<br />ASSIGNMENT<br />- Index : Integer,...

Firehose cursor and filling arrays

Thread by: TheGios, Nov 29, 2004, 1 replies, in forum: Non-Transact SQL Developer Performance Tuning

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...

CursorType and RecordCount

Thread by: TheGios, Oct 28, 2004, 1 replies, in forum: Non-Transact SQL Developer Performance Tuning

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 and inserting/updating from VB

Thread by: TheGios, Oct 28, 2004, 1 replies, in forum: Non-Transact SQL Developer Performance Tuning

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...

Surrogate or Composite KEY

Thread by: TheGios, Aug 23, 2004, 8 replies, in forum: T-SQL Performance Tuning for Developers

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...

Composite key

Thread by: TheGios, Aug 19, 2004, 1 replies, in forum: T-SQL Performance Tuning for Developers

Consider the following scenario. Table B has an identifying 1:N relationship with table A. Table A ------------------- A_ID (PK) A_Others...