Tranny Care for maximum longevity

I do not really know a whole lot about auto trannys. I've never owned one before. And with my research on this site, it seems like the svx tranny is even more prone to go bad early. So, do you have any tips on how it should be driven? I kind of know the obvious stuff, but for instance at stoplights, should I leave it in D for an extended period of time 1+ minute? Or can I save some stress on it and slip it into N? And is it bad to do the manual shifting?

Thanks for any input.