I don't think there is one that tracks connections historically. If you really don't want to run Profiler, you might try running queries against sys.dm_exec_query_stats and see if any queries...

Without everything that Gail asked for, answering this is tough, but it looks like you've got that SELECT statement as part of your initial SELECT statement. Move it into your...

Excellent information. Thank you very much.

Or even go ahead and start developing against SQL Server 2008. It's going to take you a few months to build an application that will host millions of users, so...

Damn straight I'm not sure what I'm getting into.

I recognize the issue that ORM tools are attempting to solve. I acknowledge that the various tools I've investigated do a pretty...

While the optimizer might choose to sort & join using the index on the first table, it can't use the index on the first table to access the data on...

What everyone else has said plus, assuming an OLTP system, you're avoiding scans, bookmark lookups (key lookups) and ineffecient joins in the queries. Assuming a reporting system, you're avoiding scans...

Samuel Clough (4/22/2008)

---

From a DBA perspective, iBatis.NET should really be promoted more than it is. It takes a different approach from most other mappers. It takes care of...

Andy Warren (4/22/2008)

---

Grant, I disagree that removing a tier saves time. Tiers are there for a reason! But we can agree to disagree. Bob, good for you for spanking Steve...

Samuel Clough (4/22/2008)

---

As for the comment about NHibernate not being widely used, if you look around at the upper tier of .NET developers you will find a lot of NHibernate...

Anders Pedersen (4/22/2008)

---

Horrible idea in my opinion.

Who cares if a developer saves 10%-20% (the numbers I have heard bandied aroud) by using LINQ during development time? How much time...

The honest answer is, it depends. But I've found that most of the time, performance problems are in the code and the structure, not the system. That assumes the system...

There are three tiers of code to developers, client, business, data access. If you want to make development faster, you need to reduce or eliminate one of these tiers. They...

Excellent, and timely, question. I've been trying to track down the exact same information. The whole idea of ORM (Object Relational Mapping), which LINQ and Entity Framework are examples, has...

Thanks for getting back.

At this point, to everyone except the development architect, we're still gathering information prior to making a decision. My two biggest issues come down to 1) not...