What can I do to speed it up? Thanks.

Question

What can I do to speed it up? Thanks.

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004313 More actions · Answer 1

That answers my questions #2 and #5. Still looking for answers on #1, 3, and 4. Those may also make a difference.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

halifaxdal SSCoach Points: 19741 More actions · Answer 2

Jeff Moden (8/8/2015)
That answers my questions #2 and #5. Still looking for answers on #1, 3, and 4. Those may also make a difference.

1. Is this a one-off task or will it need to be done more than once?

It is an ongoing task

3. Is it important to know which key word(s) caused the row to be selected?

No fixed rule, could be changed any time in the future

4. What is the structure of the table. Specifically, what is the CREATE TABLE statement for this table and all indexes associated with the table?

ID, three dates timestamp, 10 other columns, 1 subject column to be analyzed. I can't post the data structure here, that might cost my job. sorry

Jeff Moden SSC Guru Points: 1004313 More actions · Answer 3

halifaxdal (8/8/2015)
Jeff Moden (8/8/2015)
That answers my questions #2 and #5. Still looking for answers on #1, 3, and 4. Those may also make a difference.
1. Is this a one-off task or will it need to be done more than once?
It is an ongoing task
3. Is it important to know which key word(s) caused the row to be selected?
No fixed rule, could be changed any time in the future
4. What is the structure of the table. Specifically, what is the CREATE TABLE statement for this table and all indexes associated with the table?
ID, three dates timestamp, 10 other columns, 1 subject column to be analyzed. I can't post the data structure here, that might cost my job. sorry

Fair enough. What is the datatype of the "subject column to be analyzed"?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

halifaxdal SSCoach Points: 19741 More actions · Answer 4

Fair enough. What is the datatype of the "subject column to be analyzed"?

varchar(1000)