Viewing 15 posts - 16 through 30 (of 391 total)
January 18, 2017 at 3:18 pm
We have two SQL server 2012 bidirectional transactional replications working correctly.
Instance A (active) <-> Instance B...
January 18, 2017 at 9:11 am
Here is something that you can try, publish stored procedure execution results. It executes at the publisher and sends the results to the subscriber and executes there.
Maybe you can do...
December 15, 2016 at 4:04 pm
You could try replicating a view. The table being replicated to could have the source field. Then in the view you could calculate out the source by using @@SERVERNAME or...
December 15, 2016 at 1:29 pm
I'm the swiss army knife too
Unfortunately, in todays world we all are, or at least companies expect us to be.
Also, I, nor do I believe anyone else is advocating...
December 14, 2016 at 7:55 am
It means how can I do what I was hired to do if I'm doing what I'm not hired to do. In other words, develop software in C# when I...
December 14, 2016 at 7:27 am
Jeff,
You say so much in there that if I had to I would have to cut and paste the whole thing.
But you are correct with everything that you said. But...
December 13, 2016 at 8:23 am
I must have been sleeping on Oct 7, and accidently got it right. But I too thought you could pass a script name to R
October 14, 2016 at 9:12 am
When replicating an indexed view it will be created at the subscriber as a table.
http://www.informit.com/articles/article.aspx?p=607372&seqNum=3
The replication of multiple tables to one would not work. Each article replicated...
September 30, 2016 at 5:20 am
sanjaydut26 (9/20/2016)
Sorry, It's SQL server 2005 standard edition.
It should still work the same way.
September 21, 2016 at 7:44 am
sanjaydut26 (9/20/2016)
I am facing this issue when running DBCC checkDB
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out...
September 20, 2016 at 8:21 am
Jeff Moden (9/13/2016)
Thanks, Steve. I really appreciate the time you took to explain that. You folks definitely put some thought into that.
No problem Jeff. It took around 6...
September 14, 2016 at 5:31 am
Larry Henson (9/4/2016)
Microsoft had their "replication expert" on site for a few days about 6 months ago and she said it replication was being deprecated. She said some new version...
September 13, 2016 at 1:14 pm
Jeff Moden (9/13/2016)
GilaMonster (9/13/2016)
Jeff Moden (9/12/2016)
And, the OP responded :-).
Yes, back in 2014.
Perhaps we can find out how he used partitioning to improve performance. :w00t:
The person who...
September 13, 2016 at 8:44 am
Viewing 15 posts - 16 through 30 (of 391 total)