Viewing 15 posts - 241 through 255 (of 492 total)
shaili (5/11/2011)
Our Dev guys are referring to this document from Microsoft:
This article has a smal section in Lockdown of System Stored Procedures (pagers 13-14) that raises sp_send_dbmail as a system...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 11, 2011 at 5:39 pm
from the way you have worded your question we need to clarify the real issue.
The single point of failure is really the SAN, which may include disk, power or connectivity....
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 5, 2011 at 10:32 pm
kumar.sachu08 (4/11/2011)
. I just did a right click on SQL Server Agent inManagement Studio and manually restarted the service...but still not work.
Did you try restarting it from Configuration Manager or...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
April 11, 2011 at 10:31 pm
How is your server configured?
32 or 64 bit?
How much RAM, and what is the MAX Sql Server Memory?
Is lock pages in memory enabled and have you added the 845 trace...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
April 10, 2011 at 10:36 pm
Add this at the end of your insert statements:
declare @result varchar(500)
declare @urn int
declare Str_cur cursor
for select distinct urn from #tmp
open str_cur
fetch next from str_cur into...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
April 10, 2011 at 7:51 pm
Vertigo44 (4/4/2011)
John Mitchell-245523 (4/4/2011)
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
April 4, 2011 at 10:00 pm
Conray (4/3/2011)
I am almost 100% sure that the long running query is causing the application connection (JDBC, ReportServer) to be disconnected.
Sure, i would go about to...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
April 3, 2011 at 9:09 pm
chetanr.jain (3/28/2011)
I would prefer Log SHipping in this case.As the primary server is in Clustering mode and Secondary server is in stand-alone mode.
Why would you go for log shipping? Every...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
March 28, 2011 at 6:14 pm
It's relativly unusual to see a single resource deadlock, but it does happen. I've coined the phrase "intra object deadlock". I don't know if the phrase has been used by...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
March 27, 2011 at 6:28 pm
It looks like someone installed a db managment tool that either deliberatly or accedently added tables to msdb. This is not a good idea.
Tools like this may use the sytem...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
March 8, 2011 at 11:55 am
You can definitely do this. I've got 4 VMs on my notebook. One is a Domain Controller, one's a SAN and the other 2 are the clustered servers. Memory tends...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
March 6, 2011 at 1:50 pm
allin1 (3/1/2011)
My question:Is mirror of no use in this scenario ?
What do you infer from this discussion ? I am i being baseless?
Mirroring was designed for HA/DR, although there...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
March 2, 2011 at 3:32 pm
GilaMonster (3/1/2011)
Post the complete errors please.Yes, 'dissapearing' corruption is possible, go read Paul Randal's blog posts on that.
That was the complete error.
Besides all the details in the dump files, and...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
March 2, 2011 at 1:24 pm
Following on my previous post, look at this DMV.
dm_db_index_physical_stats(database_id,object_id,index_id,partition_number,mode) -- Function
Here's a typical example to run before and after changing an index.
select database_id, object_id, index_id, partition_number, index_type_desc,
alloc_unit_type_desc, index_depth, index_level, avg_fragmentation_in_percent,
fragment_count,...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
March 1, 2011 at 3:42 pm
Ninja's_RGR'us (3/1/2011)
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
March 1, 2011 at 3:31 pm
Viewing 15 posts - 241 through 255 (of 492 total)