Viewing 9 posts - 1 through 9 (of 9 total)
Stopped the query at 16 mins, I have the tempDB to automatically grow.
What about data types, the numset1 and 2 are now floats
August 5, 2005 at 2:58 pm
Going to stop and start sql services and free up some resources,
I think there is a gig, am going to go check.
August 5, 2005 at 2:30 pm
Just stopped it on 10 minutes, no results, going to add the fill factor.
August 5, 2005 at 2:23 pm
Sorry got caught up with other things.
Take the other index's off and maket he 1 clustered Noel?
August 5, 2005 at 2:12 pm
No Clustered index's, one on NumSet1, and another on NumSet2.
Big server [a developement server] enough ram.
August 5, 2005 at 1:31 pm
Thanks for the input everyone, though I might not be able to get this
going. Even isolating out the setVal's into its own table, the queries
seem to not finish - killing...
August 5, 2005 at 10:40 am
Ahhhh, almost. NumSet2 is returning the same number for every record.
August 4, 2005 at 3:09 pm
Yup Remi, of the above, a consolidation of the SetVal's equal to "A"
would be:
| Record | NumSet1 | NumSet2 | SetVal |
| 1 | 201645112.0 | 201645823.0 | A |
| 2 | 201646071.0 | 201646075.0 | A |
| 3 | 201646080.0 | 201646143.0 | A |
| 4 | 201646191.0 | 201646200.0 | A |
August 4, 2005 at 2:14 pm
Viewing 9 posts - 1 through 9 (of 9 total)