Viewing 15 posts - 52,081 through 52,095 (of 59,070 total)
Michaell (3/5/2008)
Would it be the time itself is pretty much an unique value already?So it don't produce a good index on it?
Absolutely not... the more unique a value it is,...
March 6, 2008 at 4:07 am
Oh no... not a problem Doug... I didn't even see your post until I posted that last one. Nope, when I said "Well then, let's show the new guy...
March 5, 2008 at 3:28 pm
Cool... let's see your solution for this, Brandon.
March 5, 2008 at 3:21 pm
You guys are crossing your wires just a bit. If you're seeing a square bracket at the end of the text FILE, you should remove that last line. ...
March 5, 2008 at 3:18 pm
No, no... don't drop all the @'s... they should be on the right side of the = sign just like GSquared showed...
March 5, 2008 at 3:09 pm
You'll need to include the ProductID in the index to do that...
March 5, 2008 at 3:07 pm
fvandenbosch (3/5/2008)
Thanks all!Being a newbie at this I stand to learn something from each of your replies. No surprise that there are several ways to accomplish the task.
Ok then......
March 5, 2008 at 2:46 pm
Perfect! I'll take two 😛
March 5, 2008 at 2:07 pm
O jeez... I totally missed that... yes, that would be the problem. Nice job, Gus.
March 5, 2008 at 2:00 pm
Thanks, Matt. Guess I won't be buying that for my home machine in the very near future... 😀
March 5, 2008 at 1:51 pm
Sometimes, I feel pretty stupid... I'm still coming up to speed on 2005 (installed at home in December)... what in the Dickens is "TFS"?
March 5, 2008 at 1:30 pm
You got that right...
By the way... thanks for taking that the right way. 🙂
March 5, 2008 at 1:20 pm
CTE... Derivied table... no difference in performance, memory usage, of disk hits on TempDB... they both equate to "inline views"...
March 5, 2008 at 1:19 pm
That's certainly another way to do it.
March 5, 2008 at 1:08 pm
Viewing 15 posts - 52,081 through 52,095 (of 59,070 total)