The data in this format will allow for contract tracing of MRSA infections. Our statisticians can pipe this through some algorithims in SAS to see if we can't find patterns...

Thanks Chris!

that appears functional. Now to tune and see how it works with a few hundred million rows!

the location_id needs to maintain the previous value - not the min/max or a cartesian product. And I need each day for each person between their admit and discharge.

running...

Yes, but those are all simple examples, throw in a couple extra fields to group your data upon - like my example.

I have the same issue - except I have SQL 2005. I found this to be a great article http://www.projectdmx.com/tsql/rowconcatenate.aspx

I am doing the for XML Path method and it is...

SQL server has become such a robust compliment of tools that it is hard to say exactly what a SQL server DBA really is. I don't think the author was...

The change from active/active to active/passive is fairly straight forward and was covered in this forum already: http://sql-server-performance.com/Community/forums/t/17534.aspx

Also there is a decent webcast here http://support.microsoft.com/kb/891798

beyond that there is...

I read the Sun article and the measurement seemed way too simplistic. If all they did was give out Kill A Watts and measure the output from 1 outlet, it...

Is anyone else having issues with MySQL's documentation and addition/removal of features? Things like database renaming (added then removed), local file imports having to use the option -L (was optional,...

How is the data moving from one location to the other? Is there a VPN? If so the VPN should create an encrypted tunnel that the data go across. But...

For me the best advice was given on Saturday Night Live:

http://consumerist.com/consumer/clips/snl-skit-dont-buy-stuff-you-cant-afford-252491.php

By not buying crap, my wife and I have been contributing 20-30% of our income to retirement accounts for the...

Lawyers also get to use libraries and search old cases to cite for their own. When programmers try to reuse code its frequently called illegal (copyright, patent...). Ironically many lawyers...

Don't forget about the SQL Server Migration Assistant for Oracle (SSMA for Oracle)

http://www.microsoft.com/sql/solutions/migration/oracle/default.mspx

It works well to transfer data and stored procedures ...

I think there is some management montra here - if at first you don't succeed, try, try again!

The question is - do you take away any sharp instruments from DBA's...

Wow how do you drive so many miles in a yr! I usually do a combo bike/bus to work - 12 miles total. My wife and I have one car...