Viewing 15 posts - 2,791 through 2,805 (of 7,164 total)
You'll need to rewrite the functionality. Exploring .NET Script Tasks is a good place to start.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 13, 2012 at 6:34 am
Jeff Moden (11/12/2012)
opc.three (11/12/2012)
Jeff Moden (11/11/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 12, 2012 at 12:39 pm
The Dixie Flatline (11/12/2012)
pattycake
pattycake
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 12, 2012 at 12:20 pm
Jeff Moden (11/11/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 11, 2012 at 6:47 pm
muthyala_51 (11/10/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 10, 2012 at 8:06 am
The driver named as "SQL Server" was released with SQL Server 2000. It's best to use a driver version consistent with the version of the SQL Server instance, else you...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 9, 2012 at 10:52 pm
Approximately the same time every day? I get this in the current shop from monitoring software that uses an old driver against my 2008 R2 instances.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 9, 2012 at 10:33 pm
Viewing 15 posts - 2,791 through 2,805 (of 7,164 total)