Viewing 15 posts - 136 through 150 (of 392 total)
I know I keep banging on about PULL replication
Totally agree, as long as the load of the subscription doesn't impact performance. This will require, in the words of MS, testing...
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
August 4, 2011 at 5:16 am
If that configuration is working for you, keep it.
Keep an eye out for agents failing. You are going to be hitting a limit in windows soon for non-interactive desktop heap...
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
August 3, 2011 at 10:26 am
300 Distribution agent: Correct, thats the load i want to reduce, for Pull we have to change the complete replication scenario of our company(we can still check that later) 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
August 3, 2011 at 9:47 am
Pujain, you need to provide much more info, such as number of publications/publishers. Number of subscribers. Number of articles in the package. Is the distributor a remote that is...
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
August 3, 2011 at 9:43 am
Unfortunately no, once the package is created you must drop it and recreate it as a merge replication package.
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
August 2, 2011 at 11:52 am
Paul
but I still get an overwhelming sense of 'meh' when I try to empathise with this viewpoint
Yes, it happens to be used by the system, but whether that makes it...
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
August 2, 2011 at 8:29 am
Homebrew
Doesn't that mean it worked on a system table ?
Since the link was for a 2008 R2 system, I tested it there.
I ran
DBCC INDEXDEFRAG(master,spt_values, 1)
which returned:
Pages Scanned Pages Moved...
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
August 2, 2011 at 8:04 am
Paul
I think that's a pretty thin argument, to be frank
That may be, but in this case the answer doesn't match the question.
In the past, I have almost always defended...
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
August 2, 2011 at 7:54 am
SQLKiwi: I'm not sure you're reading it correctly, it seems fine to me.
cfradenburg: And the correct answer is actually marked correct unless I'm missing something.
I have to disagree, and...
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
August 2, 2011 at 7:23 am
Good question, but the answer does not match the question. The question does not ask about whether the command is being depricated. The answer is actually in the link posted,...
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
August 2, 2011 at 6:35 am
Unfortunately I can't get the space. We are playing with going out and getting some external drives to do some of this. Hopefully that will work.
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
August 1, 2011 at 11:24 am
Can't copy db to other server and run checks over there?? I'm sure someone in your offcie is screaming over those budget figures right about now
I sure wish we could....
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
August 1, 2011 at 11:16 am
Ninja,
I find that to be really dangerous. The poin of checkdb is to find errors when the drive fails and to find them before the server needs to access them....
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
August 1, 2011 at 10:59 am
Ninja,
One of the things I like is that there are plenty of parameters that can be passed to taylor the process to your requirements/needs. You can, in the execution string...
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
August 1, 2011 at 8:50 am
Ninja,
I would but stopped using them when I found Ola Halingren's procedures which are all encompassing (http://ola.hallengren.com). I now use his system for alll of my maint on SS2K5 +...
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
August 1, 2011 at 8:32 am
Viewing 15 posts - 136 through 150 (of 392 total)