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...
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...
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...
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...
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.
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...
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...
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...
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...
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,...
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.
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....
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....
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...
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 +...
August 1, 2011 at 8:32 am
Viewing 15 posts - 136 through 150 (of 392 total)