How do I make where my carpet meets tile look nice?
You'll want to install carpet to tile transition strips (sometimes known as edge trim). Here is a listing from home depot. Basically it's a decorative metal strip that goes over the carpet/tile gap and provides a nice, attractive transition between the two.

Here are some instructions from eHow on how to install the transition.