Viewing 15 posts - 16 through 30 (of 392 total)
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
January 18, 2017 at 3:18 pm
We have two SQL server 2012 bidirectional transactional replications working correctly.
Instance A (active) <-> Instance B...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 15, 2016 at 1:29 pm
SPAM!!!
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
December 14, 2016 at 12:06 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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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 requires it's...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
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...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
September 13, 2016 at 8:44 am
Viewing 15 posts - 16 through 30 (of 392 total)