Viewing 15 posts - 3,076 through 3,090 (of 6,216 total)
Not sure if this fits what you're asking, but a timestamp/rowversion column will change each time any part of the row changes. Useful for doing optimistic locking.
Andy
October 18, 2002 at 4:43 am
Should work. In the null case you could just set the function to null since you already tested, save a property lookup. You could also consider handling the null or...
October 17, 2002 at 6:45 pm
Agree that I dont think max records will be an issue. Keep the columns small, index lightly, even consider inserting into a staging table during the day, do a batch...
October 17, 2002 at 6:42 pm
Maybe has to do with how its resolving the server name? Got a WINS alias set up? Local alias?
Andy
October 17, 2002 at 6:38 pm
Looks ok. Need a space between end and if. Think you need to double quote the date literal too.
Andy
October 17, 2002 at 4:59 pm
October 17, 2002 at 2:11 pm
Not sure Im clear on this, but a first try - why not just tag as deleted and then periodically clean them up?
Andy
October 17, 2002 at 7:23 am
You can also do it in code using the ADO stream object, or use the BII utility (I think from the resource kit).
Andy
October 16, 2002 at 5:17 am
Lumigent has a new freeware tool that will do it - by monitoring the log.
Andy
October 16, 2002 at 4:41 am
I just dont have enough experience with merge to see the looming roadblocks. I "think" no matter what you do with the db names you'll have to go through a...
October 16, 2002 at 4:40 am
No idea. Sorry, I know thats not helpful, but at least you know we're reading the posts! Worst case you could re-snapshot everything, but it's probably possible to move the...
October 15, 2002 at 4:43 pm
Wow. Thats a lot to follow. Certainly you could do it manually, since you really only need to compare D & E, do the inserts, deletes, then the updates (depending...
October 15, 2002 at 4:40 pm
Post the plan, we'll see if we can figure it out.
Andy
October 15, 2002 at 11:30 am
Do you have the db set to autoclose? What are your processor utilization, disk io %, disk queueing?
First one might account for the slow first query, or it could be...
October 15, 2002 at 5:11 am
Only way to know is to try I think. I wouldnt think a grid would care how the recordset was created, but havent experimented to see.
Andy
October 15, 2002 at 4:59 am
Viewing 15 posts - 3,076 through 3,090 (of 6,216 total)