Viewing 15 posts - 286 through 300 (of 405 total)
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...
November 25, 2009 at 2:23 am
You can get some idea from sys.dm_db_index_usage_stats DMV. Of course too many indexes degrade the performance.
November 25, 2009 at 2:13 am
Find out which is the cluster service account from services.
Sp_grantlogin 'domain\account'
use master ;
sp_adduser 'domain\account'
November 25, 2009 at 2:07 am
November 25, 2009 at 12:37 am
Ajay you might probably want to read this link
November 25, 2009 at 12:28 am
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...
November 25, 2009 at 12:20 am
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...
November 24, 2009 at 4:07 am
why don't you use right(fieldname,3) and left(fieldname,3)
November 24, 2009 at 3:43 am
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.
November 24, 2009 at 3:39 am
what does
sp_configure 'database mail xps'
say?
Execute
EXECUTE msdb.dbo.sysmail_help_account_sp
to see accounts configured.
November 24, 2009 at 12:26 am
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...
November 24, 2009 at 12:16 am
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...
November 23, 2009 at 2:28 am
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?
November 23, 2009 at 2:17 am
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...
September 22, 2009 at 7:23 am
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...
September 22, 2009 at 6:33 am
Viewing 15 posts - 286 through 300 (of 405 total)