You can create different file groups, add data files for the file groups. then you can move objects across file groups. But won't it be hard for you to manage...

You can get some idea from sys.dm_db_index_usage_stats DMV. Of course too many indexes degrade the performance.

Find out which is the cluster service account from services.

Sp_grantlogin 'domain\account'

use master ;

sp_adduser 'domain\account'

http://support.microsoft.com/kb/263712

Ajay you might probably want to read this link

http://support.microsoft.com/kb/263712

windows is recommended authentication for SQL server.

However you must have your own reason to opt not to do so.

In SQL server only users / groups that are granted access explicitely...

The clustered index columns are automatically included in non-clustered index. What is the size of the table? If the columns are not found in the index it has to do...

why don't you use right(fieldname,3) and left(fieldname,3)

Farren,

There is no such server level read only user to my knowledge. But you may try using DDL trigger to achieve this. Please consider performance security implication of doing this.

what does

sp_configure 'database mail xps'

say?

Execute

EXECUTE msdb.dbo.sysmail_help_account_sp

to see accounts configured.

Its little bit tough to get advice on such a wide topic

Three simple steps.

1) Use appropriate isolation levels.

2) Reduce transaction time by limiting number of commands inside the transaction. (Do...

The data for the included columns are contained in the non clustered index itself so that it does not need to go back to heap or clustered index for the...

Craig, You might want to create a stored procedure to achieve this. I don't know whether I understood you correctly. Can you explain in terms of result you want?

Thank you Silverfox.

We will plan for a memory upgrade. Or probably a 64 bit upgrade.

Meanwhile, if I setup a trace against the server, how will find out who is hurting...

Thank you both of you for quick reply.

I forgot to mention we have total four instance on the server.

Two of them uses 4 GB each. One 3GB . Another one...