Viewing 15 posts - 346 through 360 (of 1,654 total)
Did you configure SQL Agent to use the mail profile?
http://msdn.microsoft.com/en-us/library/ms186358(SQL.90).aspx
[font="Verdana"]Markus Bohse[/font]
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.
[font="Verdana"]Markus Bohse[/font]
May 15, 2009 at 3:25 am
HDMan (5/14/2009)
[font="Verdana"]Markus Bohse[/font]
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')
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
May 14, 2009 at 5:43 am
Sorry about adding the wrong link. At [/url] you find the procedure for SQL 2000 and before.
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
May 12, 2009 at 5:49 am
Check also the default schema for the user.
[font="Verdana"]Markus Bohse[/font]
May 12, 2009 at 5:36 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....
[font="Verdana"]Markus Bohse[/font]
May 12, 2009 at 5:06 am
Viewing 15 posts - 346 through 360 (of 1,654 total)