<div>
Thanks angelIII for your response, apologies if question not very clear.<br />
<br />
Okay here is better explanation of what we are trying to accomplish I hope.<br />
-We want to make it so when you log into sql, you only see production databases or reporting databases. <br />
-Want to allocate resources for production more than reporting<br />
How can we accomplish this is the most efficient manner?<br />

</div>


Thanks angelIII for your response, apologies if question not very clear.

Okay here is better explanation of what we are trying to accomplish I hope.
-We want to make it so when you log into sql, you only see production databases or reporting databases.
-Want to allocate resources for production more than reporting
How can we accomplish this is the most efficient manner?


<div>
<div class="content wysiwyg-content">
We are currently using Sql Server Standard Ed. Database Eng. for :<br />
-Data Processing: (moderate-high daily transactions, weekly uploads for Report Processing) <br />
-Data Storage: (weekly transactions, source for ReportProcessing)<br />
-Report Processing: (moderate daily transactions [queries], load into non-sql Reporting Software)<br />
<br />
1. Related to licensing, overhead [maintenance]) for the above, would it be better to have multiple instances of Sql Server or just one instance? <br />
<br />
2. If leave in same instance, best way to manage databases, tables, indexes (partitioning? views?)<br />
<br />

</div>
</div>


We are currently using Sql Server Standard Ed. Database Eng. for :
-Data Processing: (moderate-high daily transactions, weekly uploads for Report Processing) 
-Data Storage: (weekly transactions, source for ReportProcessing)
-Report Processing: (moderate daily transactions [queries], load into non-sql Reporting Software)

1. Related to licensing, overhead [maintenance]) for the above, would it be better to have multiple instances of Sql Server or just one instance? 

2. If leave in same instance, best way to manage databases, tables, indexes (partitioning? views?)



To Create or Not Create new instances

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.