More connections need more memory but 400 is not that large. SQL Server with your hardware configuration should be able to handle more connections.

You have to watch server's perform from...

It is still in Beta 2. If you can't find any information you are looking from above website, Possibily you have to wait.

No. SQL Server will place exclusive lock to the row or page or even database when it does insert/update.

http://www.microsoft.com/sql/

http://support.microsoft.com/default.aspx?scid=kb;en-us;159747&Product=sql2k

Use lock hint (nolock) in your select statement.

It sounds like you have connection pooling enabled.

Check the registry HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\W3SVC\ASP\Parameters

for entry "StartConnectionPool", if the value is set to 1, ADO and ASP will utilize connection pooling.

You may script them, paste to QA in new server, change all of them to lower case by highting them and pressing shift+ctrl+L. If your table was lower case in...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=133574

I guess there must be clustered index defined in this table. If it is, your database needs 1.2 to 1.5 times free spaces of the largest table depending on how...

Sounds like you could have memory leak, that could happen in SQL Server, applications or even OS itself. You need run performance monitor to monitor all of the counters in...

The original index name was CustomerID in order table in Northwind database. Once you change it, for example, to MyCustomerID with sp_rename, You have to modify your sp to use...

What is the size of your lagrest table?

Run server network utility SVRNETCN.exe to enable network protocol TCP/IP and Named Pipe from \Program Files\Microsoft SQL Server\80\Tools\Binn.

That is the nature of SQL Server, It allocates as much as it needs.

You can limit max memory SQL Server can use by configuring the min and max memory from...