Absolutely

let me make the example a little more descriptive. Here I will look for people with the same drug prescription on the same day. This is a frequent...

I do similiar stuff all the time - I look at prescription drug history and lab values and look for changes that would indicate adverse drug events, drug seeking behavior...

thats a fun one - this is prior to me having any coffee. So its a bit lame, but I believe I can do that with a row_number

with testcte (_ID,...

It used to matter to me, and I used to think that working in healthcare, I was making a difference. Now that I'm on my 10th yr in healthcare, I...

Bill Inmon also has a interesting article: What a Data Warehouse is Not

http://www.b-eye-network.com/view/11352

Where he sounds off about what we are terming a Data Warehouse.

I recently had to concatenate ~1.5 billion rows of text (average length of 110 characters). These were medical notes where each line was a sepearte row. I tested CLR, Stored...

I have MySQL running on a 4X (dual core) 16 GB machine. I was using INNODB, but it kept running into locking errors. I had increased the innodb_buffer_pool_size, and that...

We'd probably have to time travel back to the 70's to chat with the db designers of most hospital EMR systems. Plus all these old MUMPS/CACHE "databases" that make data...

No I have not seen that, it could be that it is dragging the match weight down enough that it is below your threshold for a match?

Regardless they will...

I'm going to quote my own article "If your data columns are anything aside from strings (datetime, int, etc.) the Mapping Type will only allow exact." I dislike this...

Yes date of birth is always good to use. And it will allocate a proximity score. Unfortunatly DOB's can differ significantly with simple typos e.g: 5/11/1972 vs...

Thanks, I may have figured it out, The binary exist in rows containing spaces (and the binary). So if I add where (PATINDEX('%[A,Z,0-9]%[A,Z,0-9]%[A,Z,0-9]%',TIUDocumentReportText) >0)

I don't get the error, but...

tried nvarchar already - that did not solve. Thanks though

I agree it is a nice to have industry experience, but absolutly not necessary.

Further I think single industry experience is a detrement. For example in healthcare (At least in...

Chris's works for me (with my samlpe table, I have not adapted to my real mess - err tables)

Most will have times associated, some will not.

Thanks for your help!