Viewing 15 posts - 1,306 through 1,320 (of 6,216 total)
I'll try to experiment a little. The idea of changing the underlying object is interesting. I guess you can get part of that by having the user own the view....
December 1, 2003 at 5:51 pm
I dont see why not. I think depends on how you want to use it. For what I needed - reporting - I was trying to hide the parameter altogether,...
December 1, 2003 at 4:50 pm
I've seen that. Not my favorite technique, but as you say, sometimes you need every bit of performance. Bill Vaughn's books cover this and quite a bit more, if you're...
December 1, 2003 at 2:04 pm
Usually because there were transactions targetted for the subscriber that were never distributed. Usually when a sub expires you run a new snapshot and you're back in business.
Andy
December 1, 2003 at 2:02 pm
There is no easy way to solve it. As Steve said, the app has to decide what to do if it can't connect to the server. If you've got a...
December 1, 2003 at 2:01 pm
November 30, 2003 at 6:23 pm
If you're a PASS member (and you are if you attended the conf) you get the subscription free, next issue out in January sometime.
Andy
November 30, 2003 at 11:38 am
Sure. A lot of times you'll have a scenario where you just want to add records - say you're a user registering for a new sql web site! If you...
November 28, 2003 at 10:53 am
Indeed. Still, I see the point. Let us talk this over!
Andy
November 28, 2003 at 6:02 am
Recovery is when SQL is going through the process of committing or rolling back transactions that were open when SQL was shut down (or the db closed I guess). The...
November 28, 2003 at 6:00 am
Totally agree. One case where things appear to be trapped is if you have a very long transaction. The log reader has to process every line even if it will...
November 28, 2003 at 5:58 am
Amazing how many things can break. Do you really have more than 255 cols? If not, I'd say the easiest would be reset the ids. Haven't tried, but I'd suspect...
November 28, 2003 at 5:56 am
Sorry, you figured it out before I even read it!
Andy
November 28, 2003 at 5:51 am
Dont know that I can answer all of that, but a couple thoughts to get us going. I think you'll do decently over a 512k pipe. Snapshots or very large...
November 26, 2003 at 8:09 am
November 26, 2003 at 7:59 am
Viewing 15 posts - 1,306 through 1,320 (of 6,216 total)