Viewing 15 posts - 346 through 360 (of 1,655 total)
Did you configure SQL Agent to use the mail profile?
http://msdn.microsoft.com/en-us/library/ms186358(SQL.90).aspx
May 15, 2009 at 6:00 am
I think if you google on "troubleshooting SQL Server performance problems" you will find thousands of articles.
But if you want any help you should give more details.
May 15, 2009 at 3:25 am
HDMan (5/14/2009)
May 15, 2009 at 12:43 am
On large databases I would advise to use sampled mode. That will speed up things quite a lot.
sys.dm_db_index_physical_stats (NULL, NULL, NULL, NULL, 'SAMPLED')
May 14, 2009 at 8:39 am
Those absolute numbers itself don't mean anything until you compare them to total wait time. The longer your server is online, the higher the values will get.
This query will tell...
May 14, 2009 at 8:16 am
I once had a similar situation where every once in a while the CPU usage would go crazy.
Because we couldn't predict when this would happen I created a job...
May 14, 2009 at 7:35 am
While the local path is optional, you must enter a network path. The network path must be a network share.
The information is used for restoring the backups to the...
May 14, 2009 at 5:43 am
May 13, 2009 at 11:39 am
kiendl.franz (5/13/2009)
First of all you should know that I've very little experience(about 1-2 years) and I hope I fit the right Category for this topic.
My Question is how should I...
May 13, 2009 at 8:04 am
Gift Peddie (5/12/2009)
Hey per the docs below you cannot run Merge Replication in SQL Server Express.http://msdn.microsoft.com/en-us/library/ms165616(SQL.90).aspx
The document clearly states that SQL Express can be used as subscriber in merge replication...
May 13, 2009 at 3:39 am
Roy Ernest (5/12/2009)
Why not try to give the db_ddladmin role to that user. Maybe that user does a Truncate command .
In that case ddl_admin would not help. Only db_owner can...
May 12, 2009 at 7:33 am
jblevins (5/12/2009)
MarkusB (5/12/2009)
Check also the default schema for the user.I'm not a trained DBA, so I've more than likely done this incorrectly. Her default schema is dbo.
That's the problem. Change...
May 12, 2009 at 7:31 am
trayalacheruvu (5/12/2009)
There are few queries which is taking time to execute..but in the application level they have set that connection timeout period as 100 sec. for testing purpose i...
May 12, 2009 at 5:49 am
trayalacheruvu (5/12/2009)
i ahve dedicated SQL server 2005 Database server for supporting one application.
Server Configuration is : O/S:64-bit, Microsoft SQL Server Standard Edition (64-bit), 4 processes with 12 GB RAM....
May 12, 2009 at 5:06 am
Viewing 15 posts - 346 through 360 (of 1,655 total)