[OT] HealthSMART problems

2010-06-22 Thread Greg Keogh
http://www.theage.com.au/victoria/computers-could-cause-deaths-warn-doctors- 20100621-ys9i.html http://m.theage.com.au/victoria/hospital-shunned-over-computer-revelations-2 0100623-yw22.html In The Age newspaper yesterday with a follow-up today. Does anyone here know what sort of a system

VS2010 Class member icons

2010-06-22 Thread Glen Harvy
Hi, The VS2010 icon for a Property value is a memoedit box with a hand/finger pointing down in the top right corner. I'm sure you all know it well so excuse my description. Now if that icon has what appears to be the reverse of a DL envelope over-imposed on it in the bottom left corner, what

Re: [OT] HealthSMART problems

2010-06-22 Thread David Connors
On 23 June 2010 09:00, Greg Keogh wrote: > > http://www.theage.com.au/victoria/computers-could-cause-deaths-warn-doctors-20100621-ys9i.html > > > http://m.theage.com.au/victoria/hospital-shunned-over-computer-revelations-20100623-yw22.html > > In *The Age* newspaper yesterday with a follow-up tod

Re: [OT] HealthSMART problems

2010-06-22 Thread Craig van Nieuwkerk
It looks like a big project probably with a lot of platforms. Seems there is a bit of Intersystems who do a lot of healthcare development. http://www.zdnet.com.au/intersystems-hits-healthsmart-goal-339298733.htm And hardware issues as well. "with surgeons forced to compete with nursing staff an

N2 CMS

2010-06-22 Thread Michael Lyons
Just wondering if anyone here has used the N2 content management system, in particular the MVC version. How did you go with it and were there any sticking points or pitfalls I should watch out for? I've been trying to access their site for the last 2 days to find out more info, but it's bee

RE: [OT] HealthSMART problems

2010-06-22 Thread Greg Keogh
>"with surgeons forced to compete with nursing staff and anaesthetists >for access to computer terminals" Remember computer terminals. We used to cue up for access to them back in the early 80s. I hope that sentence is not literally true. >If only they'd used .NET ;-) Yeah, they spent $360,000,0

Re: [OT] HealthSMART problems

2010-06-22 Thread mike smith
On 23 June 2010 11:22, Greg Keogh wrote: >>"with surgeons forced to compete with nursing staff and anaesthetists >>for access to computer terminals" > > Remember computer terminals. We used to cue up for access to them back in > the early 80s. I hope that sentence is not literally true. Let them

RE: Embedding SQL index hints into SQL commands for SQL SERVER.

2010-06-22 Thread Maddin, Peter
Thanks It is not the inserting of records into the database that is a problem. This is in fact lightening fast. The problem is obtaining a record set of data to be forwarded using a select statement. The table uses bit flags to determine which records need to be forwarded as apposed from those

RE: Embedding SQL index hints into SQL commands for SQL SERVER.

2010-06-22 Thread David Ames
Peter, It sounds like the original intent of the design is a form of "message queue" or processing queue. As the basis of the select statement is a couple of bit fields, I'm not sure that indexing them would make much of a difference - There is not much distribution of values if the only possi

RE: Embedding SQL index hints into SQL commands for SQL SERVER.

2010-06-22 Thread Maddin, Peter
Thanks When I was using Informix on SCO Unix (That feels like a lifetime ago) I had a job that ran update statistics on a regular basis (every hour from memory). In fact one had to do this or strange things happened. With SQL Server, I understood that this can be set to done automatically. I ju

Re: Embedding SQL index hints into SQL commands for SQL SERVER.

2010-06-22 Thread noonie
Peter, If the DBA has created that index on the bit column and if the normal process of your store-and-forward results in a very few records matching your criteria then the index may actually help your query times. As to whether thi

Re: VS2010 Class member icons

2010-06-22 Thread Jason Keats
http://msdn.microsoft.com/en-us/library/y47ychfe.aspx Maybe it means Internal? On Wed, Jun 23, 2010 at 9:02 AM, Glen Harvy wrote: > Hi, > > The VS2010 icon for a Property value is a memoedit box with a hand/finger > pointing down in the top right corner. I'm sure you all know it well so > excuse

Re: [OT] HealthSMART problems

2010-06-22 Thread Grant Maw
$360M makes QLD Health Payroll system debacle (which is based on SAP/Workbrain) a baby at a mere $40M, and I echo Greg's sentiments about doing it for half that price. It'll never happen but I'd love to see a post-mortem (pun intended) detailing what made this project such a catastrophe. Amongst o

Re: [OT] HealthSMART problems

2010-06-22 Thread silky
On Wed, Jun 23, 2010 at 1:21 PM, Grant Maw wrote: > $360M makes QLD Health Payroll system debacle (which is based on > SAP/Workbrain) a baby at a mere $40M, and I echo Greg's sentiments about > doing it for half that price. > > It'll never happen but I'd love to see a post-mortem (pun intended) >

RE: Embedding SQL index hints into SQL commands for SQL SERVER.

2010-06-22 Thread Greg Low (greglow.com)
Also, if you find yourself building a queue, you should look at Service Broker which is a transacted queue that's already properly designed. Regards, Greg From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Ames Sent: Wednesday, 23 June 2010 12:

RE: Embedding SQL index hints into SQL commands for SQL SERVER.

2010-06-22 Thread Maddin, Peter
I actually made the requested changed to my SQL command but there was no discernable difference. I really wasn't expecting any. Regards Peter Maddin Applications Development Officer PathWest Laboratory Medicine WA Phone : +618 9473 3944 Fax : +618 9473 3982 E-Mail : peter.mad...@pathwest.wa.gov.a

RE: [OT] HealthSMART problems

2010-06-22 Thread Ken Schaefer
Poor contracts are definitely a problem. The rest (IMHO) is a combination of science and art, and when you have enormous projects then: a) You simply can’t hire 500 “a-team” people b) There is way more complexity and requirements than people imagine in the beginning c) Everythin

Re: [OT] HealthSMART problems

2010-06-22 Thread David Connors
On 23 June 2010 16:14, Ken Schaefer wrote: > And sometimes a, b and c end up being so bad you have a huge IT debacle. > The problems in health payroll were pretty much inexcusable irrespective of project complexity. The current issue of not being able to pay anyone could have been avoided if they