The stock SD sights are adequate but you often can find other sights that you like more. I am not real big on "night sights" -- if it is too dark to see the sights, I probably can't see well enough to identify the target beyond a doubt.
The sights mentioned above are good choices. I installed a M&P OEM rear sight on the SD9VE slide and a Novak fiber optic front sight, but it worked loose -- so I re-installed the white dot sight. The older SD9 has a Warren Tactical rear sight (all black) and a Hi-Viz fiber optic front sight.
There are lots of combinations and none are wrong, if they work for the shooter; you may find yourself trying different sights and changing them a couple of times until you are happy with what you have...
I agree with the recommendation to use the MGW (Maryland Gun Works) sight pusher for all installation and adjustment jobs. It is much better than using a punch or a block of wood... well worth the money.