Viewing 15 posts - 54,691 through 54,705 (of 59,078 total)
Jack Corbett (10/8/2007)
I had a solution I was going to post but Jeff's was faster by magnitudes. I'd go with his solution.
Heh... :blush: Thanks for the Kudo, Jack......
October 8, 2007 at 4:51 pm
Sergiy (10/8/2007)
I believe this topic is a perfect illustration for the article "Why programmers cannot program?".They take care about everything - formatting, performance, style, but ignore building correct algorithm absolutely.
Absolutely...
October 8, 2007 at 4:45 pm
Sergiy (10/6/2007)
What if nobody made any order on Tuesday?
Jeff, don't you think the Thursday calculation should include zero orders for Tuesday, not whatever number...
October 8, 2007 at 4:41 pm
Guess my other question would be... why do you even need this type of info in a fact table or dimension? This should be simple lookup data.
October 8, 2007 at 4:27 pm
dhay1999 (10/8/2007)
I'll also look at the cube and rollup that the other poster suggested, I don't know what that will entail, but the reporting piece cannot be changed readily, so...
October 8, 2007 at 4:25 pm
a_mail.address (10/7/2007)
Such a tthing doesn't exists. In this project we don't have a WreckageDate. Such a thing is never saved, because it is not entered in any of the input...
October 8, 2007 at 4:19 pm
30 Gig? Can you even buy a harddisk that small anymore? Go buy a 300 GB disk or two from ABC Warehouse or something... shoot, I think even...
October 6, 2007 at 8:49 pm
I'm no expert in this area, but I don't think that just setting the shell to nothing will do it... don't you also have to drop or close the shell...
October 6, 2007 at 8:44 pm
I've heard a lot of folks gripe that using SMALLINT and SMALLDATETIME actually slowed things down because of the datatype byte mismatch with computer "word" size on PC's. So,...
October 6, 2007 at 8:41 pm
What wrong with DICE, Monster, and all the other job sites? You get a better selection and in more places than I ever saw on this forum...
October 6, 2007 at 8:12 pm
If you have to tract all that other stuff about a card, why worry about how many rows you have... it's gonna have to be stored somewhere. Perhaps a...
October 6, 2007 at 8:10 pm
When in doubt, simple tests will keep you from barking up the wrong tree or missing a perfectly good fire hydrant 😛
October 6, 2007 at 8:04 pm
3. SELECT indentity(int,1,1) as ID, * into #tab from T are very common.
Shoot, that's one of my favorites. If the boys in Redmond ever get rid of Select...
October 6, 2007 at 8:01 pm
It's probably a good thing you don't know how because my recommendation is not to store images in SQL... store them in files and store the file names in SQL....
October 6, 2007 at 7:55 pm
Heh... when are you going to get to all the things I sent you, Steve?
October 6, 2007 at 7:53 pm
Viewing 15 posts - 54,691 through 54,705 (of 59,078 total)