Viewing 15 posts - 14,011 through 14,025 (of 39,967 total)
Probably, and glad it's moving faster.
Large deletions across a table should be done in batches of 10,000 or 100,1000 or some reasonable level that allows you to stop it if...
May 4, 2012 at 8:42 am
The distributor cannot be a lower version than the publisher, that's the issue.
If you log ship to ServerB, it will work, but if you failover, you are stuck on 2008...
May 4, 2012 at 8:41 am
Are they all located in the same network area? Same subnet, physical location?
May 4, 2012 at 8:33 am
Check the Event logs for service information.
May 3, 2012 at 12:55 pm
Sean Lange (5/3/2012)
Maybe we can get Steve to add an exception so the spiders will ignore this one. 😛
Pass, you type it, you're on the hook for it.
May 3, 2012 at 9:54 am
How does what help?
If this is just text data, is there a reason you can't just index the text data? If it's in Filestream, I know you can full text...
May 3, 2012 at 9:51 am
What updates? Are you talking about updating at the source or destination? It's not clear from what you are posting.
May 3, 2012 at 9:44 am
Your subquery 1 after the WHERE clause looks to be pulling lots of data for the NOT IN. I think that's your problem. You need to build some join so...
May 3, 2012 at 9:39 am
You'll have to explain more. What do you mean by updateable with filters?
I assume filters mean that you are producing a publication that joins data from two or more tables...
May 3, 2012 at 9:27 am
Looks like you are missing a paren in your subquery before the NOT IN
May 3, 2012 at 9:05 am
novak 32871 (5/3/2012)
May 3, 2012 at 8:49 am
The distributor is usually the issue. It must be equal to the publisher, so from 2008 -> 2005, you need a 2008 distributor.
May 2, 2012 at 3:59 pm
phonetictalk (5/2/2012)
And kudos to Steve for using his widely read tech newsletter to advocate the importance of retirement savings, even (and especially) for younger workers.
Thank you.
May 2, 2012 at 3:54 pm
Revenant (5/2/2012)
Perl can do a lot with one command.
So could APL, but it was PITA to read.[/quote]
Arrgggghhhh, I think I disliked APL more than any other language. Neat idea, raised...
May 2, 2012 at 2:21 pm
Viewing 15 posts - 14,011 through 14,025 (of 39,967 total)