Viewing 15 posts - 31 through 45 (of 178 total)
From my perspective I'd say understanding the context of the data you're manipulating allows you to see the bigger picture. However I'm a bit of a mongrel.
Choosing the right tool...
October 23, 2009 at 4:53 am
Quite - as the DBA you should be revoking all privileges on all tables and only allowing pre designed updates via stored procedures - that's the only way you can...
October 2, 2009 at 4:37 am
jcrawf02 (10/1/2009)
How in a global enterprise would you account for sales beginning/ending across time zones? Multiple...
October 1, 2009 at 8:39 am
Just do it in your business logic - when you want to add a product to a promotion ensure the application has to call a stored procedure - in that...
October 1, 2009 at 8:31 am
As to the person wondering about discount rates, there are pros and cons to that. The pro, as mentioned, is not maintaining a separate list of hard prices. ...
October 1, 2009 at 7:57 am
jcrawf02 (10/1/2009)
Mod -1, how is this article supposed to help me get a date?!
Read the title - "Part 1 - The Problem". It's a demonstration - you read the article...
October 1, 2009 at 7:14 am
Why not just have a mathematical price modifier attached to the promotions table rather than a promotion price - that way you can apply a promotion to a group of...
October 1, 2009 at 4:13 am
It is true - I just set up a MOSS server without knowing what I was doing, I still don't really understand conceptually what is happening but as soon as...
September 23, 2009 at 3:10 am
Sorry Steve,
Much as I'd like to vote for it I appear to be lost in Microsoft Passport - I can't get them to send me a new password because my...
September 17, 2009 at 8:43 am
I'm with Steve,
That would be an extremely useful function....
September 17, 2009 at 7:56 am
Phil Factor (9/11/2009)
September 11, 2009 at 3:10 am
RTF, I was merely saying that if you run any given query on SQL versus Access then SQL will be faster, particularly bearing in mind Bob's tables are on the...
September 11, 2009 at 2:47 am
Depends what you're trying to achieve Bob.
A pass through query will just literally pass the query string to the DB, execute it, then return the results. Lord knows what Access...
September 10, 2009 at 8:59 am
Thanks Phil, there I was thinking I was a decrepit old dinosaur sticking with my completely functional ODBC connections and eschewing Linq and suchlike on the basis that I could...
September 10, 2009 at 4:38 am
Very true Dave, and this was the crux of my argument.
The problem is quite complex, as it has to account for differing levels of technical maturity around our global concerns,...
August 28, 2009 at 4:23 am
Viewing 15 posts - 31 through 45 (of 178 total)