Forum Replies Created

Viewing 15 posts - 1 through 15 (of 161 total)

  • RE: Need Recommendations for Document Database

    Eric M Russell - Wednesday, February 14, 2018 7:17 AM

    aureolin - Friday, February 9, 2018 10:37 AM

  • RE: Need Recommendations for Document Database

    Jeff Moden - Wednesday, February 14, 2018 6:43 AM

    aureolin - Friday, February 9, 2018 10:37 AM

    February 14, 2018 at 10:04 am


  • RE: sp_spaceused rewritten as one query (no cursors)

    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...

  • RE: The Case for Upgrading

    Snark of the day:

    Microsoft Licensing - promoting Open Source for twenty years.

  • RE: Combined wildcard and between statements

    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...

  • RE: Unique Key Constraint that shouldn't happen?

    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.

  • RE: Massive IOs!

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

  • RE: Massive IOs!

    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...

  • RE: Massive Blocking

    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...

  • RE: Specialists or Generalists: Who are best as Developers?

    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.

  • RE: LINQ

    Happy to help, and good luck! 😉

    Steve G.

  • RE: LINQ

    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....

  • RE: LINQ

    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...

  • RE: LINQ

    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...

  • RE: LINQ

    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...

Viewing 15 posts - 1 through 15 (of 161 total)