I'm not saying that you should debug the code, I'm saying that you should *insist* that the developers give you the queries being executed when a timeout occurs. Is there...

tresiqus (3/31/2014)

---

Thanks, but the problem description I get doesn't have anything specific, typically just a "dropped connections - you need to check the indexes on the server" request. The...

Eric M Russell (3/6/2014)

---

dmbaker (3/6/2014)

---

Eric M Russell (3/6/2014)

---

It's true that by coding batch processing logic within the application, your SQL code can be simplified and constructed in a more cross-platform...

Eric M Russell (3/6/2014)

---

It's true that by coding batch processing logic within the application, your SQL code can be simplified and constructed in a more cross-platform fashion. Basic SELECT, INSERT,...

DEK46656 (3/6/2014)

---

dmbaker (3/6/2014)

---

At the moment I would think the best approach would be is to design the database “correctly” and implement the GUI through something like MVC. Leave as...

At the moment I would think the best approach would be is to design the database “correctly” and implement the GUI through something like MVC. Leave as much of...

Entity Framework can do a "mass delete" by executing an arbitrary SQL statement. It's arguable as to whether that's actually EF since you're essentially "stepping out" of the framework to...

My apologies, it wasn't clear in your initial post that that this was the case and it's someting that seems to be often forgotten. I'm certainly glad to hear it...

Step 0 - Talk to the business

Are you sure you need a data warehouse at all? Discuss needs with your users and make sure you understand the business. If you...

Did you mean "salient?" I suppose salacious would work, but it gives your post a whole different meaning. 😀

Can you post more details? Sounds like you're using .NET (since you mention app.config) but knowing what language you're coding would be helpful (e.g. c#? VB.NET?) as would what version...

I think that "database abstraction layer" isn't really what you think it is, or at least your view is incomplete. Microsoft's Entity Framework, as well as other ORM tools, are...

"When they need to construct a class in C#, they don't heave out a prosthetic GUI to do it. They just cut code"

Well, I think one could call Visual Studio...

patrickmcginnis59 10839 (5/13/2013)

---

dmbaker (5/13/2013)

---

Really? That's a pretty broad brush you're using...

Really? That's a pretty broad brush you're using there. I don't...