Check this out.

http://searchoracle.techtarget.com/ateQuestionNResponse/0,289625,sid41_cid571200_tax294550,00.html

The performance impact will largely depend on what both the instances will be used for. There is very less overhead by just adding a new instance which is sitting idle....

Antares,

I agree with you.Connection pooling has nothing to do with no. of connection and can be used for fine tuning your performance. The answer which i gave was reference...

There is a tab for connection pooling under ODBC administrator.

Check this article for more information about connection pooling

Check this great article from Ken Henderson.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_01262004.asp

By default, SQL Server will only be able to use 2 GB of memory. If you don't want to use extra memory, don't specify...

Check the article below. It talks about upgrading Personal edition to Enterprise edition.I believe you can use the same process for upgrading to enterprise edition from standard edition. Make sure...

I do remember of running into this a while back.SQL does not like Linked servers when you connect using windows authentication. We ended up using SQL Accounts. I don't remember if it...

Not with SQL 2000. With what i know is that SQL 2005 will by tying the logins into the local system accounts. This will fecilitate enforcing all kind of user...

Can you give some more details about the alert ?

Try checking the SQL error log file. It should give you information of what database is backed up when and also what kind of backup it is.

From all the replies above, what i understood is that it talks about about  disk usage utilization and disk queing. I agree with the disk usage concept and you might want...

When you look at the job history, under what account does the job say to be executing ? Is it sa, or domain account or some other account ? If...

You can execute the following procedure for your own login. You need sysadmin or security admin privilege to execute this procedure for other users.

exec sp_defaultdb loginname, databasename

e.g. for login victoria...

Just a thought.

I have never heard of disk degradation because of space issues. The only closest thing i can think about is that when the disk fills up and with...

Check the articles below.

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

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

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

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

http://support.microsoft.com/?kbid=867878