Global temp is not a bad idea, but easy to get mixed up if you have concurrent users. Honestly, what is the point in this case of modifying a table...

I'll try to find time to experiment. Definitely it seems like there are times when the query planner gets confused, must default to a "safe" plan. Have you tried adding...

It is a property you can set in DTS - basically it'll be faster to move 10000 rows per batch than 1000 in most cases, keep in mind that you...

Memory on the client or the server? I wouldnt expect server memory to drop, it just had to work to cache the data, why would it release it a few...

They work pretty well. Have had no problems so far. My only complaint is it wont let you run a plan on something like all db's that start with X...

We're using a small Dell/Clariion Fibre setup, 10 disks, very nice. No problems with it all and it is damn hard to saturate the disks compared to scsi.

Andy

Im looking forward to .Net, the VB variety as well. Got some very nice features.

Andy

I have not - wouldnt expect to matter unless you were memory constrained and it was getting dumped out of cache a lot - which shouldnt happen if its being...

That sounds ok to me.

Andy

Hello Baabu - this was a test message? Please dont hesitate to post any question if you have one!

Andy

The recordset is SOOOO powerful, lots of cool features that are seldom used. May try to explore more of these. Was also thinking of trying to show "why" and "how"...

I'll keep in that mind for the follow up. Thanks for the feedback.

Andy

Thanks! We'll probably do another one or two articles on it, but really there are plenty of books on the subject - just wanted to get people interested, give them...

Win2K/SQL2K is a killer combination. Very solid in my experience. After all, Win2K is old technology, XP is almost here. Seriously, you'll be SO glad you went with Win2K -...

No issues in beta either. Nothing in production yet. Got other fish to fry right now!

Andy