Viewing 3 posts - 1 through 3 (of 3 total)
yeah, i added the clustered index after the insert to improve performance. the insert took just over an hour and a half but adding the clustered index took around...
November 21, 2008 at 7:48 pm
#901950
it was something of a math experiment. I was doing a specialized inner join on itself to find all prime numbers from 1 to a billion. its been...
November 21, 2008 at 10:57 am
#901781
i had a need for a large number table, from 1 to 1 billion in just one table so neither of these solutions worked. i used cte to get...
November 19, 2008 at 4:47 pm
#900791