So, what is the opposite end of the spectrum? You guessed it... A large depth of field that shows much of the photograph in focus. This is what you get with most point and shoot cameras so use this sparingly as well. You achieve this with a very narrow aperture (large f-stop number). See the example below and notice how the rocks in the foreground and the trees in the background are sharp.
Prints available for sale at eldridgestudios.com starting at $50.00
What do you use? Well, that is totally up to you. Go out and try different f-stop numbers to see what effect it has on a given subject. You simply have to understand depth of field. Again, I must state that the use of depth of field is one of the photographer's greatest tools. Use it wisely!