Viewing 15 posts - 2,791 through 2,805 (of 7,168 total)
I see this a lot in multi-user environments. Chances are good that you and your colleagues are not running the exact same build number of SSIS, i.e. same SQL Server...
November 14, 2012 at 1:25 am
carsten.kunz 37074 (11/13/2012)
opc.three (11/13/2012)
carsten.kunz 37074 (11/13/2012)
For the SQL Server I also usually set max degree of parallelism to 1, under advanced server settings.Why do you do such a thing?
I have...
November 14, 2012 at 12:05 am
You'll need to rewrite the functionality. Exploring .NET Script Tasks is a good place to start.
November 13, 2012 at 9:47 pm
Transactional Replication is worth exploring. It could work, if your schema supports it. All tables need a Primary Key and I would venture a guess that more databases exist where...
November 13, 2012 at 9:35 pm
Database Mail issue could be circumstantial, it may not be to blame, the lock timeout may just be a symptom of the root cause. PLE drops typically occur after a...
November 13, 2012 at 9:14 pm
marc.snoeys (11/13/2012)
D.Post (11/13/2012)
CASE
WHEN $action = 'INSERT' THEN 'ADDED'
WHEN $action = 'DELETE' THEN 'REMOVED'
END ACTION
BUT: the question was rather why there is a difference in behavior between...
November 13, 2012 at 7:04 am
carsten.kunz 37074 (11/13/2012)
For the SQL Server I also usually set max degree of parallelism to 1, under advanced server settings.
Why do you do such a thing?
November 13, 2012 at 6:34 am
Jeff Moden (11/12/2012)
opc.three (11/12/2012)
Jeff Moden (11/11/2012)
November 12, 2012 at 1:14 pm
Sorry, I wish I had a more targeted referral for you but Updatable Subscriptions are not something I have specifically worked with in a production setting so the best I...
November 12, 2012 at 12:39 pm
The Dixie Flatline (11/12/2012)
pattycake
pattycake
November 12, 2012 at 12:20 pm
Jeff Moden (11/11/2012)
November 12, 2012 at 12:13 pm
There are built-in caching frameworks from Microsoft for ASP.NET as well as Windows Forms that are mostly configuration-based. Depending on your requirements you may not have to write one lick...
November 12, 2012 at 11:53 am
I think you're doing everything right with how you're describing the workload and how things are setup. Depending on how well-defined the subset of rows that accepts deletes is, you...
November 11, 2012 at 6:47 pm
muthyala_51 (11/10/2012)
November 11, 2012 at 3:56 pm
All types of replication subscriptions. When you run some of the replication configuration stored procedures these Linked Servers are used to communicate configuration changes between instances.
November 10, 2012 at 8:06 am
Viewing 15 posts - 2,791 through 2,805 (of 7,168 total)