SQL Server Database
I will need a SQL Server to be able to accept connections from 30 different IPs.  Is the licensing of the SQL Server based on the number of connections?

James

---------------------------

Hi,

Also, the SQL server will be hosting a table with a big database.  The table has columns like:


PortID - int
PortType - varchar(30)  (can have 30 different unique values)
PortTime - datetime

As the number of records will be large and the searches will always specify a PortType, can we somehow segment the table by PortType to facilitate the search speed?

SQL Server Database
===

I will need a SQL Server to be able to accept connections from 30 different IPs.  Is the licensing of the SQL Server based on the number of connections?

James

---------------------------

Hi,

Also, the SQL server will be hosting a table with a big database.  The table has columns like:


PortID - int
PortType - varchar(30)  (can have 30 different unique values)
PortTime - datetime

As the number of records will be large and the searches will always specify a PortType, can we somehow segment the table by PortType to facilitate the search speed?
