Viewing 15 posts - 52,156 through 52,170 (of 59,070 total)
Covering index would contain both sets of columns. Clustered index would make inserts take a huge amount of time on this. Make it a non-clustered index.
March 4, 2008 at 10:12 am
mobasha (3/4/2008)
can u try thired party tools, i have saw some can do this.
That's nice... what are they?
March 4, 2008 at 9:59 am
I suspect it would be a little cumbersome to implement
Heh... you got a problem with {ctrl-c}{ctrl-v}???
March 4, 2008 at 9:36 am
It's simple... if it ALWAYS there, just don't include the last character.
March 4, 2008 at 9:34 am
dean gross (3/4/2008)
March 4, 2008 at 9:30 am
If you install a highpass filter, inversely proportional or so it would seem...
March 4, 2008 at 9:21 am
Carl Federl and I did some pretty good testing a couple of years back and it very much supports what Matt says... it depends on the function, how it's written,...
March 4, 2008 at 7:57 am
Almost forgot... if you copy from 1 line ABOVE the code window to 1 line BELOW the code window, leading spaces will also be preseved.
March 4, 2008 at 7:50 am
Heh... ya beat me to it... thanks, Matt.
March 4, 2008 at 7:48 am
No, no! Copy the code and paste it into MS Word... do a Search and Replace...
Search for ^l (circumflex small-"L") and replace it with ^p (circumflex small-"P"). Then...
March 4, 2008 at 7:44 am
The temp table is built in the first of the 5 queries I posted. Temp tables are session sensitive... they only "live" as long as the current session does....
March 4, 2008 at 7:41 am
Heh... It's always good to have someone else confirm the test in their own way. Thanks, Ian.
March 4, 2008 at 7:01 am
Viewing 15 posts - 52,156 through 52,170 (of 59,070 total)