Viewing 15 posts - 811 through 825 (of 1,353 total)
One thing I will say is that while the default behavior of the recordsets was to go for direct access to the tables, it's actually very straightforward to switch them...
August 22, 2013 at 6:59 am
I favour moving as much application business logic into stored procedures as is possible, thereby abstracting out the UI layer from the business logic
I think I can help with wondering...
August 21, 2013 at 11:48 am
I have not used EXCEPT often, but when I have, I have found it very fast. The circumstances were very circumscribed: from a listing of about 200K phone numbers...
August 21, 2013 at 7:17 am
As a VB Programmer, I developed a lot of processes using disconnected recordsets. I used stored procedures to retrieve the initial sets. However, the additions and changes made...
August 21, 2013 at 7:11 am
Hate to seem picky, but did I miss were you said at the beginning what GIS stands for? If so, I apologize, but if not, you really should have...
August 20, 2013 at 7:17 am
It definitely depends. Do you have previous experience doing other databases. For me the design skills I picked up designing MS Access applications and the T-SQL skills I...
August 20, 2013 at 6:56 am
If it helps more, I've told my children from time to time "Family comes first, but not always."
August 19, 2013 at 1:01 pm
Yes, it is a fact of IT life that some study has to occur off hours. 15+ every week sounds like a lot, though. However, there are times...
August 19, 2013 at 6:51 am
I think most people here, and elsewhere, will fall on the side of clarity. But it's just a opinion.
However, as you can see, it's an opinion held by many...
August 2, 2013 at 9:01 am
How many times have you had to provide an answer, verbal or written, as to what these arbitrary and meaningless prefixes mean? Add up that time, and then multiply that...
August 1, 2013 at 11:19 am
saFinance is shorter than FinanceStaging and dwKyle is much shorter than KyleDataWarehouse. The users don't see these names, so they don't have to be user friendly. I can...
August 1, 2013 at 8:44 am
RonKyle (7/31/2013)
--------------------------------------------------------------------------------
Most would probably say it's overkill, but I prefix my OLTP databases with db, my staging areas with sa, and my OLAP database with dw. The names are otherwise...
August 1, 2013 at 7:13 am
The mandated standard here is 4 characters vice 5.
I have some short names. If I remove my two letter prefix I already outlined (db, sa, dw) most would fit...
August 1, 2013 at 6:53 am
Most would probably say it's overkill, but I prefix my OLTP databases with db, my staging areas with sa, and my OLAP database with dw. The names are otherwise...
July 31, 2013 at 3:36 pm
I don't know enough about the internals to be sure of the answer. If the relationship had been something other than both joining directly to organization name, I could...
July 31, 2013 at 7:54 am
Viewing 15 posts - 811 through 825 (of 1,353 total)