Viewing 15 posts - 17,071 through 17,085 (of 39,902 total)
Yes, most people don't read discussions. I have tried to add a note to controversial articles to point people to the articles, but haven't typically pointed to new articles.
January 14, 2011 at 9:32 am
Could there be some backup job that's writing to tape or the NULL device? If the diff is going down in size, you have something that is resetting the diff...
January 14, 2011 at 9:00 am
andycao (1/14/2011)
...recovery times never require a cot at work.
An excellent metric to use.
January 14, 2011 at 8:46 am
I like you talking about posters. Tells me where to go look (or where not to go)
January 14, 2011 at 8:43 am
Yep, that makes sense. I'd like to get a standard section/piece of text at the top and bottom of each article to do the forward/back pointers.
January 14, 2011 at 8:42 am
That's weird. I'll have someone look at it.
January 14, 2011 at 8:40 am
You have a good explanation, John. Just not sure that it's entirely valid to paint a paradigm or framework as "less secure" with a broad brush.
The flip side is that...
January 14, 2011 at 7:48 am
TravisDBA (1/14/2011)
January 14, 2011 at 7:44 am
If you shrink a log, you are reclaiming inactive space (subject to a few constraints) for the OS by reducing the physical size of the log. However regrowing it can...
January 14, 2011 at 7:38 am
I think I might ask for a 64-bit test from then. The file formats, and many things are the same. Unless they have some 32 bit driver, it ought to...
January 14, 2011 at 7:34 am
First, get backups running on production servers in an organized fashion. Just built a policy for now, then start getting things changed based on criticality.
Second, as you set things up,...
January 13, 2011 at 5:32 pm
You can drop the login without any consequences on the primary system.
January 13, 2011 at 3:58 pm
First, you might look at this script for a more efficient index rebuild: http://sqlfool.com/2009/06/index-defrag-script-v30/
An index rebuild is a logged operation. So rebuilding the indexes will result in lots of log...
January 13, 2011 at 3:41 pm
What I have heard regarding CUs is that they are tested and the support people at MS have confidence in them. However, they do not get the wide range of...
January 13, 2011 at 3:25 pm
You create a login and user on the source system.
You then migrate that login to the new system (the user will come through log shipping) using the same SPID.
This should...
January 13, 2011 at 3:21 pm
Viewing 15 posts - 17,071 through 17,085 (of 39,902 total)