Viewing 15 posts - 1 through 15 (of 161 total)
February 14, 2018 at 10:06 am
February 14, 2018 at 10:04 am
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...
May 10, 2016 at 11:03 am
Snark of the day:
Microsoft Licensing - promoting Open Source for twenty years.
September 3, 2015 at 12:19 pm
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...
June 1, 2012 at 10:00 am
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.
March 16, 2012 at 5:54 pm
Thanks for the link - exactly what I was looking for.
October 28, 2011 at 2:31 pm
Evil Kraig F (10/27/2011)
October 28, 2011 at 1:52 pm
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...
September 8, 2011 at 11:50 am
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.
August 29, 2011 at 4:50 pm
Happy to help, and good luck! 😉
April 28, 2011 at 2:41 pm
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....
April 28, 2011 at 1:44 pm
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...
April 28, 2011 at 1:32 pm
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...
April 28, 2011 at 1:30 pm
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...
April 28, 2011 at 1:09 pm