Viewing 15 posts - 5,116 through 5,130 (of 7,168 total)
"Best" will be relative. I suggest you do some reading into what Service Broker offers in terms of activation:
http://msdn.microsoft.com/en-us/library/ms171617(v=SQL.90).aspx
September 24, 2011 at 7:37 am
For the record Database Mail is built on Service Broker technology. In the past we needed to create the "insert into queue table + job to look for records" architecture...not...
September 23, 2011 at 11:34 am
I am no expert at reading these but you have one of the more interesting ones I have seen....lots of players 😀
It appears that CSTool.dbo.RequestContents is a popular object. This...
September 23, 2011 at 10:13 am
The picture is nice, but the XML content of the deadlock graph is preferable. Save it with a .txt extension and attach it to the thread please.
September 22, 2011 at 8:45 pm
The Conditional Split Transformation in SSIS will make quick work (and by quick I mean quick to develop and perform quick too) of the file you are being asked to...
September 22, 2011 at 9:21 am
Sure, HTH.
At first glance I thought maybe you needed an EXEC before the proc call in the second email attempt, but that rule only applies if there is more...
September 22, 2011 at 9:06 am
Post the job script.
September 22, 2011 at 6:50 am
Ninja's_RGR'us (9/21/2011)
I c your point. The problem is that it's going to be the same change management limitations !
True. It might be an easier sell than getting a maintenance...
September 21, 2011 at 5:28 pm
Ninja's_RGR'us (9/21/2011)
opc.three (9/21/2011)
@M_E_K, if this query is consistently pegging your DB instance where it affects other activity consider a defensive move...add a MAXDOP hint to...
September 21, 2011 at 5:08 pm
In that case you do not need the "SQL Server Integration Services" service to be running at all in order to support the SSIS packages you're migrating. You only get...
September 21, 2011 at 3:27 pm
File system...so you're executing the all SSIS packages using dtexec.exe?
September 21, 2011 at 3:09 pm
aleee_shaikh (9/8/2011)
1. Free online MCQS based tests and competition opportunity.
2. Create and joincustomized groups, tests and competitions.
3. Share your...
September 21, 2011 at 3:02 pm
Is there a problem in doing this, as I have lots and lots of SSIS packages (SQL 2005) already in place and that are running daily called in sql jobs...
September 21, 2011 at 2:59 pm
You do not need to wait for another deadlock. In 2008 you can pull the graphs of deadlock events that already occurred:
http://www.sqlservercentral.com/articles/deadlock/65658/%5B/url%5D
Pull some of the graphs and post them to...
September 21, 2011 at 2:53 pm
You're welcome, HTH.
September 21, 2011 at 2:50 pm
Viewing 15 posts - 5,116 through 5,130 (of 7,168 total)