A table of all possible combinations? Is that feasible? If you have 10 diagnoses, you have over 3-million possible combinations, and the numbers go up fast from there.

I'm working on one. I have the outline put together, working on turning it into more than that.

DECLARE @D VARCHAR(100) = '13MAR2009:00:00:00';

SELECT CAST(STUFF(STUFF(STUFF(@D, 3, 0, '-'), 7, 0, '-'), 12, 1, ' ') AS DATETIME);

The speed really depends on how you set it up.

I currently have a table with over 30-million rows of varbinary(max) data in it. I'm in the process of partitioning...

Roy Ernest (2/18/2010)

---

There are couple of guys/ladies here in this forum who have done quite a bit for the community and have a pretty good knowledge that deserve a MVP...

CirquedeSQLeil (2/18/2010)

---

Would that be the "Shoot-Aim-Ready" firing...

Personally, if I'm ever wrong (it's bound to happen someday), I prefer to just be put in front of a firing squad. 🙂

I would definitely consider breaking that into its own partition.

As for performance, et al, the only way to be sure is to test it thoroughly.

Use Word. I've tried to get something "better", but really it just takes more time and gets the same result.

I'd say the thing to do is look for companies hiring a junior DBA position. Trying to get a senior position in order to learn senior skills is backwards....

I think you'll need to grant the ability to run jobs to the group.

Is it possible the product of the job can be produced in another manner? If, for...

GilaMonster (2/17/2010)

---

GSquared (2/17/2010)

---

Well ... technically I'm not either, because mine's one of the Android phones ... but really, yeah, you're the last person left on the planet who doesn't use...

Well ... technically I'm not either, because mine's one of the Android...

Ideally, you should have something that monitors...

Woot! 🙂