<div>
Great, thats what I had been thinking to do. &nbsp;Thanks for the input:)
</div>


Great, thats what I had been thinking to do.  Thanks for the input:)

<div>
<div class="content wysiwyg-content">
I'm designing a new high volume database from scratch and was planning to have very specific SQL stored procedures. &nbsp;I want lean logic that a particular application (ASPX) section or two will own. &nbsp;The idea is to get away from these jack-of-all-trades procedures. &nbsp;How will using many smaller procs affect performance? (We have a large number of concurrent users...250+ per minute connecting)
</div>
</div>


I'm designing a new high volume database from scratch and was planning to have very specific SQL stored procedures.  I want lean logic that a particular application (ASPX) section or two will own.  The idea is to get away from these jack-of-all-trades procedures.  How will using many smaller procs affect performance? (We have a large number of concurrent users...250+ per minute connecting)

Specific SQL Procedures

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.