Stolen -- err, 'borrowed'.

Actually, this came at a very appropriate time. We're just getting ready to talk to a vendor about their vastly over-spec'ed database server. This query helps...

Snark of the day:

Microsoft Licensing - promoting Open Source for twenty years.

You could do something like:

Where left(Diag1,3) > 'C00' and left(Diag1,3) < 'C97' ...

or you could create a CTE that extracts the left 3 characters of your diagnosis code (please forgive...

Allow me to make an overly obvious suggestion: Instead of just catching the error, add a logging step in the error handler so you can see which values are failing.

Thanks for the link - exactly what I was looking for.

Evil Kraig F (10/27/2011)

---

Out of curiousity, OP... Usually the older systems were heavily tuned and something 'tipped', or something new exploded (which wouldn't be on 32bit, these days). Do...

In my third party app, I typically see the "Set Textsize XXXXXX" as simply the first statement in a batch. It's the second or third statement in the batch that's...

This is a "good programmer" / "bad programmer" problem rather than a generalist / specialist issue.

Companies need both specialists and generalists, with the balance depending on what they do.

Happy to help, and good luck! 😉

Steve G.

In my case the transaction volume is pretty mild. Where I do have the possibility of performance issues is that some of the queries to the database are quite complex....

I think that what your hearing is a result of bad programming practices rather than a direct indictment of the ORM. I'm using EF 4 with CodeFirst and don't have...

This leads directly to one of my "Great Fears"(*). ORM's are very nice and, as a developer, I like EF4 with Code First - but like VB before it, I'm...

The answer is a bit complicated. First, for a garden variety Linq2SQL or EntityFramework (EF) query, yes, it does show up as an ad-hoc query just like any other query...