Hi,

I wanted to start a general discussion more for getting some thoughts
on what other people think/practice out there just to see how far (if
at all) I'm off base on my own thoughts.

My primary experience is developing applications using VB or DotNet.  I
have some sql skills but they are limited.  In a previous company our
concept on SQL was that it was used for very simple work, (i.e. insert,
update, delete, select, etc).  The applications we wrote did the bulk
of the work.  We had very limited DTS's wrtten and stored procs were
very small.

In the company I've been working at for the last year, we have two
different mindsets on this issue (to be honest, the numbers of people
who feel like I do have dwindled, we've lost some of our DotNet
developers in the last few months).  A very large amount of work is
being developed in SQL and even where our DotNet applications are
concerned, I have seen some push for putting a lot of the work into the
stored procs instead of having them be simplistic like I mentioned in
the previous paragraph.  I have seen stored procs called by dot net
apps that call other stored procs, that call others, etc.  Some of
these procs are like minature apps in of themselves.

I have a hard time wrapping my brain around why anyone would do this.
I believe that this type of design is problematic for maintainence at
the very least.  But I would think it puts an unnecesary burden on SQL
too.  I just don't know how to prove it.  When I've mentioned this,
some of the feedback I get is that my concept  would cause network
traffic that is unnecessary (i.e. multiple stored proc calls, etc).
Again, I am unsure how to test/verify such a claim.

I would think the best approach is to have your business logic stay in
DotNet if you have a DotNet app.  Obviously if you have a process that
doesn't get put into an application at all, then I believe the logic
should stay in SQL.  I do question the necessity of having that type of
work happen as often as I'm seeing it though.  DotNet can be used to
write pretty much any type of application that you would do in SQL.

I'm curious as to how other groups approach this issue?  Any feedback
at all - regardless of how it would be in regards to my own opinion on
this subject would be much appreciated.

Text DataType and XML Explicit in SqlServer 2005
Hardware Upgrade Options
SELECT & SET
BCP in a stored procedure with out xp_cmdshell
Better way to create large table?
Help with RAND()
Help replicating a sql server database
Upate based on multiple WHERE clauses
insert into table from stored procedure
Defrag/Reindex Table