My first question is how do you use Sprites in DirectX9? Currently I am rendering two triangles to create a rectangle and then having a texture applied to form my character tile. From what I heard using Sprites might be easier for me to use. So just curious how can I use it and if there is any benefits for me to use it than what I have been currently doing. I doing a RPG game in Directx, C++ and its one of the few issues that is confusing me.

The D3DX helper library contains a sprite class. The MSDN docs for it are quite thorough. Try this link.